Is there a way of setting up a shortcut to a database for MS SQL Server Management Studio
Yes you can use the following command:
ssms.exe -S SERVERNAME -d DATABASENAME -E
You can either run this using run, or put it into a .txt file and change the extension to .bat and run that.
Some more information can be found by runing smss.exe /?:
Usage:
ssms.exe [-S server_name[\instance_name]] [-d database] [-U user] [-P password] [-E] [file_name[, file_name]] [/?]
[-S The name of the SQL Server instance to which to connect]
[-d The name of the SQL Server database to which to connect]
[-E] Use Windows Authentication to login to SQL Server
[-U The name of the SQL Server login with which to connect]
[-P The password associated with the login]
[file_name[, file_name]] names of files to load
[-nosplash] Supress splash screen
[/?] Displays this usage information