I am using Solutions and Projects in SQL Server Management Studio to organize my scripts and files. I want to set a default database for a project so that when I start a new script file it will start with that database selected, instead of "master" which is the SQL login's default. I do not want to change the default database for the login, only the project.
Can this be done? I have searched online and cannot find it. I keep getting results for changing the default database for a login which I do not want.
I checked the Project properties but there is no setting for this. I also checked the project's connection properties, but there appears to be nothing in there.
Thank you.