SharePoint Sidekick - Identity column starts from zero instead of one

8
sidekicks

Sidekick it

Identity column starts from zero instead of one

published 794 days, 18 hours, 15 minutes ago posted by

admin 797 days, 11 hours, 34 minutes ago

Identity column starts from zero instead of one

I was experiencing a strange problem. Identity field of a table is set to [1,1] by generating script. Every time, when I drop the whole database, and then re-create it by running script in SQL Server 2005 Management Studio, and then insert a record into that table programmatically, SQL Server set identity field value of that first record to 0 instead of 1! I was gone mad until I have comeup with a small piece of code like this. The code will delete all the rows from all the tables in your database. So u...

category: Development | | clicked: 16 | source: www.scriptstar.co.uk | show counter code

	Border color: Sidekick it Backcolor: Sidekick it Forecolor: Count Backcolor: Count Forecolor: update reset
	Comments Promoted By 1 comment posted. url Identity column starts from zero instead of one Monday, March 28, 2011 12:30:14 PM GMT #1 Narendra 789 days, 19 hours, 27 minutes ago said: Hello, this looks cool. Testing the comments.... To post your comment please login or signup admin support bee Narendra colinellis9 hnnllznrdy juanmejina nahgeeortiz

SharePoint Sidekick is a place where you can find the latest Microsoft SharePoint stories to increase your skills and share your opinions. Enjoy participating in this community and see which other people in our industry are getting kicks (for a change, this time sideways).

faq »

Identity column starts from zero instead of one

1 comment posted.

Welcome

Unstoppable traffic generator

Open ID Login

Standard Login

Forgot Password?

Sign up