Hi,

Is there a way to suppress the prompt askinng to save when using SSMS 2008
query editor, as there was in SQL 2000?

I don't see it in the options.

Thanks.

Alan

_____________________________

Alan Z. Scharf
Grapevine Systems
New York City

Alan Z. Scharf (ascharf (AT) grapevines (DOT) com) writes:
I've been banging my head about this since the first betas of SQL 2005,
and the developers at Microsoft refuse to understand. They think that
if you have a file, you have a file and you want to save it. They don't
understand that if you are a DBA, you just run a bunch of ad hoc-queries,
that you don't care about.

But you could always vote for
https://connect.microsoft.com/SQLSer...dbackID=124686



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland,

Thanks for your reply.

I thought I just couldn't find the option.

I voted.


This reminds me of the same kind of issue in SharePoint slide library. My
client has need to update 55 slides automatically each month from SQL Server
financial data. That part works fine. However, when individual users open
up their respective PowerPoint presentations using slides from the library,
they are forced to answer yes or no, for EACH slide, EVERY month, from a
prompt asking them if they want to accept the new data on each slide.

Obviously they shouldn't have to be bothered with this, since the system has
already been set up to automatically update all the slides.

MS Developer support said there is no way to suppress this 'Accept' prompt
in Sharepoint , PowerPoint, or with VSTO. There isn't even such an option
in the SharePoint or PowerPoint object models to shut this off. They say
such an option would violate their SharePoint document security model.

Hence, my client gave up on using SharePoint slide library for what would
have been a perfect and very productive application of the library.


Regards,

Alan


"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote