In followup to the blog post about SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of? here I had an email asking about how to determine the logins provisioned in the SQL Server sysadmin fixed server. Here is the TSQL that I got from CSS person when troubleshooting a problem to obtain the above result: SELECT p.name AS [Name] FROM sys.server_principals r INNER JOIN sys.server_role_members m ON r.principal_id = m.role_principal_id INNER JOIN sys.server_principals...(
read more)
No comments yet, be the first one to post comment.