sql serversql server 2014ssms
I'm able to launch SQL Server Management Studio (2014) from command line using something like below.
ssms.exe -E -S myservername -D -mydatabasename
However, I'm not sure how to pass additional connection parameters such as multisubnetfailover=true
Is it possible to do this via commandline or through 'Target' on SSMS windows desktop properties?
Have you considered SQLCMD?
Here's an article on Using the SQLCMD command line utility.
You can execute adhoc SQL statements, or run .sql scripts.
The following example runs the C:\MyScript.sql script from the command line and outputs the queries and results to a text file located at C:\MyResults.txt.
C:\Windows>sqlcmd -S NOTTINTRA3\SQL2005 -i C:\MyScript.sql -o c:\MyResults.txt -e
I haven't played with themes, but you can set per-connection properties, including the color of the connection info bar at the bottom of the query tab. And these settings are saved.
If you have a query tab open, go to "Change Connection" (either the button in the button bar, or via the Query menu, top item should be Connection >, and when it pops up the "Connect to a Database Engine" dialog, click on the Options >> button. Go to the Connection Properties tab and the bottom option is Use custom color:. Check the check-box for it and click on the Select... button on the right.
Just use different colors for the different servers/environments.
Technically speaking, there is a means of programmatically interacting with SSMS: write a plug-in / extension. I will list some resources below that deal with this topic. I have not tried it yet myself, but it seems as though it might be a lot of effort for a one-time config update. On the other hand, if SSMS will not record the setting for 100, let alone 400, separate connections (not sure what the limit is), then maybe this would be worth the effort.
Best Answer
Unfortunately not. If you type
ssms.exe -?or look at the documentation you'll see the list of possible options:So there is no option to specify a connection string or additional connection properties.