Wednesday, December 30, 2009

Error during save changes of sql table design in SQL server management studio 2008.

In SQL Server Management Studio 2008,if we open table in design mode to make changes and then click save after making changes in table structure it will give error.

Error says.



this is due to there is "Prevent Saving changes that require table re-creation" option is enabled in SSMS-2008.



To work around this Just Un-Check "Prevent Saving changes that require table re-creation" option from Tools > Options >Designers.

hope this will help you.

Thanks.


No comments:

Post a Comment

Comments posted on ASP.Net Ajax Tutorials Blog are moderated and will be approved only if they are on-topic and not abusive. Please email me or my team for tech-support or blogging related questions. Avoid including website URLs in your comments - Thanks Author