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 | February 27th, 2015|SQL|0 Comments