Show Connection String in Management Studio

Here is some code I found to show connection string in Management studio

http://dba.stackexchange.com/questions/20528/how-to-check-connection-string-in-ssms2012

type this code in Managent Studio SQL Query Window

select
‘data source=’ + @@servername +
‘;initial catalog=’ + db_name() +
case type_desc
when ‘WINDOWS_LOGIN’
then ‘;trusted_connection=true’
else
‘;user id=’ + suser_name()
end
from sys.server_principals
where name = suser_name()

By | 2016-07-11T00:12:42+00:00 February 27th, 2015|SQL|0 Comments

About the Author: