I cook and take food photo. I build databases and love to talk about it.

Saturday, 20 September 2014

On 16:24 by Unknown in    No comments

Friday few minutes before 5pm scenario: 

You have a dinner date with your loved ones and you want to leave work on time. Just before you were thinking you are done for the day, your manager asked you to ALTER a database table (for example adding a new column or any DDL statement). You know it will take only few minutes for a small table. You opened SQL Server Management Studio (SSMS) to ALTER a table, added a new column. Everything is fine up to the point of saving the table. Bang! You have an Error message and your DBA is gone for the day. You know this is very simple task but you just can't think.

Saving changes is not permitted

Here is the solution:

If SSMS is not already opened then open SSMS, on the Tools menu, click Options. In the navigation pane of the Options window, click Designers. Clear the Prevent saving changes that require the table re-creation check box, and then click OK. 

Hopefully, this little 'SQL know-how ' will save your romantic evening.

For Further Reading: http://support.microsoft.com/kb/956176


Post a comment