Author |
Topic |
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-15 : 12:46:03
|
How to list the sysadmins on a server. Or listing members of sysadmin server role?------------------------I think, therefore I am - Rene Descartes |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-15 : 12:47:29
|
I got SYS.server_role_members, need to look from here.------------------------I think, therefore I am - Rene Descartes |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-15 : 12:49:55
|
see sp_helpsrvrolemember==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-15 : 12:53:02
|
Great nr! You are my man!------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-16 : 16:13:19
|
server role- sysadmin(double click).you will see . |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-16 : 16:19:18
|
quote: Originally posted by sodeep server role- sysadmin(double click).you will see .
..I have around 30 servers. Can't do that...------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-16 : 16:23:42
|
'How to list the sysadmins on a server?'That was your question. Thats why i said. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-16 : 22:23:55
|
>> I have around 30 servers. Can't do thatCan run query from single server via linked servers. Anyway, you have to connect to each server to get info. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-17 : 07:50:45
|
With 30 servers (and more instances?) I would be tempted to hold the connection info in a table and use openrowset or osql to get the data rather than maintain linked servers.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-17 : 08:56:27
|
quote: Originally posted by nr With 30 servers (and more instances?) I would be tempted to hold the connection info in a table and use openrowset or osql to get the data rather than maintain linked servers.
I am using SQLCMD for the purpose. 1. I have a domain account for all the users. 2. Hence I can use trusted connection parameter –E3. SQLCMD has a interesting parameter :CONNECT which can be used to connect different servers I hope this gives a fair idea what I am doing; let me know if some needs more information. Thank you all. ------------------------I think, therefore I am - Rene Descartes |
|
|
|