December 7, 2015 at 8:29 am
I'm trying to figure out how to open a default Solution in SSMS. I have all my scripts saved into multiple projects and those are in a single solution. I just want that solution to open automatically when I start up SSMS every time.
I know I've done it in the past but can't seem to find anything on Google about how I did it. I seem to remember something about changing the shortcut to open the solution but can't seem to figure it out.
Any help is appreciated.
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
December 7, 2015 at 8:37 am
SQLJocky (12/7/2015)
I'm trying to figure out how to open a default Solution in SSMS. I have all my scripts saved into multiple projects and those are in a single solution. I just want that solution to open automatically when I start up SSMS every time.I know I've done it in the past but can't seem to find anything on Google about how I did it. I seem to remember something about changing the shortcut to open the solution but can't seem to figure it out.
Any help is appreciated.
Double click the solution file to open it in SSMS?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 7, 2015 at 9:22 am
I'm trying to get SSMS to "automatically" open the solution every time I click the icon. If there is no other way then I suppose I could just create a shortcut to the solution file and just open it.
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
December 7, 2015 at 9:30 am
SQLJocky (12/7/2015)
I'm trying to get SSMS to "automatically" open the solution every time I click the icon. If there is no other way then I suppose I could just create a shortcut to the solution file and just open it.
I don't know for sure. I have never tried to do that because I would find it incredibly annoying. You could also change the shortcut to ssms.exe to include any number arguments. https://msdn.microsoft.com/en-us/library/ms162825.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 21, 2017 at 3:11 pm
By the way, for anyone looking to do this, you just need to add the path to the solution to your shortcut Target path on the icon. Be sure to put a space and surround it by double quotes.
"C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe" "E:\SQL Scripts\Scripts.ssmssln"
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply