Monday, March 12, 2012

open and shortcuts for management studio at the same place

Hi im pretty new to sql server management studio. I want to know if its possible to create shortcuts to certain database or even tables. I connect to a sql server hosting company that hundreds of databases which take mins to load the list and i need to scroll down and find my database. Filter doesnt work for database names. Is it possible to create a shortcut for the same db same view same login. Thanks

what u can do is

(a) go to the properties of the SQLManagement ShortCUt on u r desktop

(b) u will have something like this : "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

(c) just add -S <ServerName> -d <databaseName> -U <UserName> -P <Password> to it.

for me its looks like : "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe" -S tEST-ABC -d gpx -U sa -P sa

i hope i have answered u r question

Madhu

|||

That shortcut opens the query window against that database for that server.

There is no direct way to achieve but you can set SSMS to 'open in empty environment' and then you can select the object explorer to connect to desired server.

No comments:

Post a Comment