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-05-24 : 03:34:40
|
| Hi all,I want to know all sysadmins available in sql server 2000 but i dont know which should i use get this details .Can someone let me know the script?ThanksVijay...Asking for help is always helpful |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-05-24 : 06:26:05
|
| see :http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145016 |
 |
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2010-05-24 : 13:14:55
|
Hi Dear,Thanks for you help .I checked your first script Server Level Permissions .it gives all details ,But the tables which are in the scripts not the part of sql server 2000 ...This script works fine on sql server 2005 and above but does not work in 2000...I hope you understand what i was looking...I have script which work in 2005 and gives output but it does not work in 2000..For 2005 and above:SELECT 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 I need same result in sql server 2000quote:
Originally posted by sodeep
see :http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145016
|
|
|
|
|
|
|
How to get all sysadmins in sql server 2000