December 15, 2008 at 11:43 am
I've read that you should use the "Indentity Specification" section in the Management Studio but for me, the options are grayed out.
I can't seem to find out why it's not allowing me to change it. SQL Server 2k5 is currently installed onto my laptop so everything is done locally.
December 15, 2008 at 11:59 am
Is the field a number field, int, bigint, numeric, decimal. If not, it won't allow you to create an identity.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 15, 2008 at 12:58 pm
That would be why then.
December 15, 2008 at 1:12 pm
Well, I didn't just tumble out of a Vault, you know.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply