Wednesday, March 28, 2012

Opening SQL Server Management Studio for Query only

I finally noticed today that if I open a SQL script file on 2005 installation, it opens the query window ONLY in SQL Server Management Studio. Otherwise, no object explorer, ect.

Since MS will not provide independent Query Analyzer as in SQL 2000 and earlier - that I provide to power end users, I want to be able to give them call to "SqlWb.exe" to open only with query window.

I checked program opions (SqlWb.exe /?) with no answer.

Does anyone know how to open SQL Server Management Studio for Query window only?

This is a way we can give our power clients the "Query Analyzer" type toolset for SQL 2005 without them using full SQL 2005 Management Studio.

Create an empty SQL script file on your "H", etc. drive. Create new SHORTCUT on desktop using below string (edit if your path for EXE or SQL file is different)

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe" H:\Empty_SQL.sql -nosplash

No comments:

Post a Comment