Loop through each instance on a server

Question

Viewing 7 posts - 1 through 8 (of 8 total)

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

Eirikur Eiriksson SSC Guru Points: 182951 More actions · Answer 1

Quick thought, how about cmd net start and parse the output?

😎

SQLHeap Hall of Fame Points: 3572 More actions · Answer 2

I don't want to start anything, just trying to get info. I'd like to stay with a SQL query.

There is an exception to every rule, except this one...

Eirikur Eiriksson SSC Guru Points: 182951 More actions · Answer 3

SQLHeap (4/15/2015)
I don't want to start anything, just trying to get info. I'd like to stay with a SQL query.

without any parameters it only lists the services, should be easy to parse the output.

😎

SQLHeap Hall of Fame Points: 3572 More actions · Answer 4

That lists out the services yes, but I'm looking for the account that the SQL services are running under.

There is an exception to every rule, except this one...

sql-lover SSCoach Points: 18530 More actions · Answer 5

I use powershell for this type of cross server activities. Here's an example: USING POWERSHELL TO LOOP THROUGH A LIST OF SQL SERVER DATABASES[/url]

Eirikur Eiriksson SSC Guru Points: 182951 More actions · Answer 6

Just ran your code on a multi instance box (10 running and 4 not running), all showing up in the results, could this be a permission issue?

😎

BTW: the services not running show up with NULLs in SQLServiceAcct and SQLAgentAcct.

SQLHeap Hall of Fame Points: 3572 More actions · Answer 7

GRRRR, doesn't work for me at home either:crazy:

There is an exception to every rule, except this one...