471,108 Members | 1,274 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Connect to SQL Server dialog

Hi,
Is it possible to avoid the last used server being in Query Analyzer
'Connect to SQL Server' dialog by default(when I click on File/Connect
in Query Analyzer) - I don't want to apply 'truncate table' scripts to
a production server by mistake!
Thanks

Jul 23 '05 #1
1 1310

<po***********@aol.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Hi,
Is it possible to avoid the last used server being in Query Analyzer
'Connect to SQL Server' dialog by default(when I click on File/Connect
in Query Analyzer) - I don't want to apply 'truncate table' scripts to
a production server by mistake!
Thanks


I don't think that's possible - if you're concerned about running scripts in
the wrong place, then you can reference @@SERVERNAME in your scripts, or
always begin a transaction and require a manual COMMIT or ROLLBACK. Another
option is to use a dedicated administrator account for deployments to
production servers.

But all those approaches have drawbacks as well, and in the end there's no
catch-all substitute for being careful about what you're doing.

Simon
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Mark Fisher | last post: by
5 posts views Thread by Mike L | last post: by
reply views Thread by Neff | last post: by
9 posts views Thread by Peter Lux | last post: by
4 posts views Thread by =?Utf-8?B?RGF2ZQ==?= | last post: by
1 post views Thread by jwgoerlich | last post: by
reply views Thread by Hugo Kornelis | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.