1
kudos
spam Kudos Remove

TSQL to obtain the logins provisioned in the SQL Server sysadmin fixed server
published 580 days, 1 hour, 24 minutes ago posted by sasa 587 days, 1 hour, 44 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