Thursday, September 07, 2006
SSMS Macros? Nope But We Do Have the Command Line
SQL Server Management Studio (SSMS) is missing, IMO, macro ability like we have (and have had) in Visual Studio. Oversight? I don't know but it's needed.
One thing you can do to automate SSMS is to use its command line switches. For example, I modified my shortcut to SSMS to include the -S switch. When I launch SSMS now, it doesn't ask which server to connect to; it auto-connects (using Windows Authentication) to the server.
Another one I like is the -nosplash.
To do this on your box, all you have to do is to locate the SSMS icon, right click on it and select "Properties", then append -S <server name> -nosplash
If you mess up, no problem. You'll receive a prompt with the correct switches and their meanings.
One thing: make sure you have a space between -S and your server name. I don't know whether it's a bug or what but it's certainly inconguous with other SQL Server command-line tools...
One thing you can do to automate SSMS is to use its command line switches. For example, I modified my shortcut to SSMS to include the -S switch. When I launch SSMS now, it doesn't ask which server to connect to; it auto-connects (using Windows Authentication) to the server.
Another one I like is the -nosplash.
To do this on your box, all you have to do is to locate the SSMS icon, right click on it and select "Properties", then append -S <server name> -nosplash
If you mess up, no problem. You'll receive a prompt with the correct switches and their meanings.
One thing: make sure you have a space between -S and your server name. I don't know whether it's a bug or what but it's certainly inconguous with other SQL Server command-line tools...
Technorati Tags: SSMS, Management Studio, SQL Server Management Studio, SQL Server 2005, SQL Server, Microsoft SQL Server
