1
kudos
spam Kudos Remove

TSQL to obtain the logins provisioned in the SQL Server sysadmin fixed server
published 686 days, 16 hours, 28 minutes ago posted by sasa 693 days, 16 hours, 49 minutes ago
Wednesday, July 07, 2010 1:37:08 PM GMT Wednesday, June 30, 2010 1:16:43 PM GMT
TSQL to obtain the logins provisioned in the SQL Server sysadmin fixed server
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)
category: News | clicked: 1 | | source: sqlserver-qa.net | show counter code
tags: builtin\administrator, privilege, Security, server principal, SQL Server, TSQL

No comments yet, be the first one to post comment.

To post your comment please login or signup