Menu
I was wondering if anyone knew of a way to do this.
I have tried looking through some of the options in the SQL Server Management Studio 2008 but I can't find how to do it, I am sure it is simple.
Can anyone tell me where to turn this off?
Thanks,
EDIT: This is the Prompt that comes up any time you open a new query window , do your stuff and then try to close w/o saving.
714
Open SQL Server Management Studio. On the Tools menu, click Options. In the navigation pane of the Options window, click Designers. Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.
To access the Advanced Save Options Dialog Box, select the small rectangle at the right of the Save button and then click Save with Encoding. Use this dialog box to specify an encoding for the file and the characters to use at Line endings.
At the command prompt, type sqlcmd. Press ENTER. You now have a trusted connection to the default instance of SQL Server that is running on your computer.
To disconnect the connection after the query completes, from the menus go to Tools > Options > Query Execution > SQL Server > Advanced and select "Disconnect after the query executes". By checking this option, after the query executes the database connection will be disconnected.
You can't turn this off
However, if you want to do something about it, vote for it on connect:
http://connect.microsoft.com/SQLServer/feedback/details/308372/permit-nameless-windows-that-do-not-need-saving-in-ssms
186
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
