Retrieve SQL Instance Connect Info

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

  • 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

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

    Thank you Steven for the script!!


    Thank you!!,

    Angelindiego

  • Thanks for the script.

  • 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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply