Friday, December 3, 2010

Problem altering tables in SQL Server 2008

In SQL Server 2008 there's one option that prevents saving changes to table or alter script.

You might get error as shown below.

To resolve the issue follow steps mentioned below.

Go TO -> Tools -> Options -> Designers -> Uncheck Prevent saving changes that require table re-creation.

Here are the snaps for above solution.

AShish Chotalia

No comments:

Post a Comment