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.
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)