Cannot change table to make column an Identity??

Last Post 11 Jan 2010 06:15 AM by Markus_SQL. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Markus_SQL
New Member
New Member

--
11 Jan 2010 06:01 AM
In SQL Server 2008 I am using Management Studio to change a column to be an Identity, when I click save it states that I cannot do this.

Saving changes is not permitted. The changes you have made require the following tables to be dropped and recreated.

Why can't this no longer be done? I have done this countless times in SQL 2000. All I am doing is changing a column to be an Identity plain and simple. I use another tool called DBArtisian and it does this change without a problem.
Markus_SQL
New Member
New Member

--
11 Jan 2010 06:15 AM
I found it. There is an option by default that prevents this from happening. Someone pointed me in the right direction.

Designers, Table & DB Designers Prevent Changes, removed check in box and I am able to make the change.
Markus_SQL
New Member
New Member

--
29 Jan 2010 09:40 AM
Very true RM. I guess I was just wondering why I could not make any table change at all in Management Studio and I found my answer.


Acceptable Use Policy
---