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