Retrieve SQL Instance Connect Info

Question

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

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

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

Lee Linares SSCrazy Points: 2727 More actions · Answer 1

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 · Answer 2

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

Thank you Steven for the script!!

Thank you!!,

Angelindiego

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

akljfhnlaflkj

SSC Guru

Points: 76202

May 2, 2016 at 3:40 pm

#1876060

Thanks for the script.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

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.