Wednesday, November 6, 2013

How to fix "Cannot insert duplicate key in object . The duplicate key value is" problem while insert a new record in SQL Server?

First all, Run:
dbcc checkident([tablename],noreseed)
to check the latest id

Then run
DBCC CHECKIDENT ([tablename], reseed, latest id)
to correct latest id

How to solve Google OVER_QUERY_LIMIT problem?

Google usage limit:
The Google Geocoding API has the following limits in place:

2,500 requests per day.
Google Maps API for Business customers have higher limits:
100,000 requests per day.
https://developers.google.com/maps/documentation/geocoding/#Limits

Two choices:
1. Buy a business acccount
2. Use Proxy to change your ip address