While running (F5) Saved Procedure from produced Schema of SQL server database project, I have to supply connection string (SQL Server connection window prompts). Morever the SP is firing from the default Master-database.
To solve i used "Use " at first from the SP. But this isn't viable because I have to provide "Use " for those hundreds of SP's, and much more over each time the conection string too.
Can there be in whatever way where we are able to specify the bond string in CMD variable or config where it may be selected while running the SP from schema objects? Any assistance is appreciated.
I believe you're searching for the "Initial Catalog" setting.
DatabasesEqualsmyServerAddressInitial Catalog=myDataBaseUser Id=myUsernamePassword=myPassword
Have a look at http://www.connectionstrings.com/