January 30, 2012 at 8:59 am
Hi,
I have searched the forums and couldn't find the answer.
What I am trying to do is modify the primary field of a table to have an Is Identity = Yes, Identity Increment = 1, Identity Seed = 1.
As I say this is easy to do on my other server, but this machine just won't let me edit the initial field Is Identity. Just stays grayed out.
I have tried what others suggest, delete the column name and try again, but this still doesn't work for me.
Any suggestions would be greatly received as it is starting to drive me insane!!>!:hehe:
January 30, 2012 at 9:03 am
What datatype is the column?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 30, 2012 at 9:23 am
Hi it is a uniquenumber.
However as soon as you asked that was my error. I have now changed it to be an int and of course I can now get to setting the elements I require.
Thank you for your prompt.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply