May 2, 2016 at 12:06 pm
Hello,
I would like to be able to select the full SQL connection string and use it in a POWERSHELL script. Is there a query that I can run in SSMS that would return the full connection string?
Something like...
SELECT @@SERVERNAME, DB_NAME, etc
FROM MASTER (or whatever)
Thank you all for your continued support.
Everyone has a plan until they get punched in the mouth. --Mike Tyson
May 2, 2016 at 12:57 pm
my advise is to look at https://www.connectionstrings.com/ and see lots of possibilities - and obviously the manuals may have a bit more options.
May 3, 2016 at 11:53 am
Is there a way to SELECT the full data source from SSMS?
Everyone has a plan until they get punched in the mouth. --Mike Tyson
May 3, 2016 at 12:47 pm
no
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply