Retrieve SQL Instance Connect Info

• swhaley

  SSC Enthusiast

  Points: 119

  More actions

  April 1, 2013 at 7:46 pm

  #291829

  Comments posted to this topic are about the item Retrieve SQL Instance Connect Info

• Lee Linares

  SSCrazy

  Points: 2730

  More actions

  April 11, 2013 at 9:20 am

  #1605646

  Great script! Thanks for postingit. One minor change I would make would be to change the subquery to resctrict the database id to less than 5.

  I ended up with 2 entries because I had a database named SMSDB.

  Here is the editted subquery:

  (select left(af.filename,3)from sys.sysaltfiles af where af.name like '%MSDB%' and af.fileid = 1 AND af.dbid<5) as 'Drive',

  Thanks again.

  Lee

• Angelindiego

  SSCertifiable

  Points: 6048

  More actions

  April 11, 2013 at 9:38 am

  #1605662

  Me too Lee, thanks for the quick fix!!!

  Thank you Steven for the script!!

  ---

  Thank you!!,

  Angelindiego
  

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 2, 2016 at 3:40 pm

  #1876060

  Thanks for the script.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 2, 2016 at 3:41 pm

  #1876061

  Lee Linares (4/11/2013)

  ---

  Great script! Thanks for postingit. One minor change I would make would be to change the subquery to resctrict the database id to less than 5.

  I ended up with 2 entries because I had a database named SMSDB.

  Here is the editted subquery:

  (select left(af.filename,3)from sys.sysaltfiles af where af.name like '%MSDB%' and af.fileid = 1 AND af.dbid<5) as 'Drive',

  Thanks again.

  Lee

  Thanks for the update.