Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vijays3
Constraint Violating Yak Guru
354 Posts |
 Posted - 2010-06-08 : 09:56:39
|
| Hi all,I have a script which can generate the all sysadmins in sql server 2005SELECT TOP 10 SPMember.name AS [login name], SPRole.name AS [role name] FROM master.sys.server_principals SPRole INNER JOIN master.sys.server_role_members SRM ON SPRole.principal_id = SRM.role_principal_id INNER JOIN master.sys.[server_principals] AS SPMember ON SRM.[member_principal_id] = SPMember.principal_id But i need to generate the all sysadmin in sql server 2000please assist me on this |
|
|
|
|
|
how to get the all sysadmin in the sql server 2000