I’m using this code to reset the identity on a table: DBCC CHECKIDENT(‘TableName’, RESEED, 0) This works fine most of the time, with the first insert I do inserting 1 into the Id column. However, if I drop the DB and recreate it (using scripts I’ve written) and then call DBCC CHECKIDENT, the first item […]
I have restored one db back up to my SQL server. I have an ASP program which is accessing the db.When i am running this ,i am getting an error login failed for this user.What exactly i have to do for this ??