Friday, March 9, 2012

Open a file in Management Studio

Hi,

The most thing I hate in Management Studio is when I select
File/Open/File and then select a SQL script file to open, Management Studio displays a "Connect to Database Engine" dialog box. In SQL Server 2000 Query Analyzer, open the file in the current connection.

Is there any setting to change in MS in order to get the same behaviour as QA, please don't tell me for security enforcement reasons you cannot.

Thank you

For security enforcement reasons you cannot...

... Well, that seemed to be the best idea when we shipped SQL Server 2005. But then we heard from the people who have migrated from SQL Server 2000 and they didn't like having to click Connect or Cancel all the time. We've modified the default behavior in SQL Server 2005 SP2 to be more like Query Analyzer. There will be a CTP released where you can check out the functionality soon. Check http://www.microsoft.com/sql/ periodically for more information.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

No comments:

Post a Comment