SQL Server Performance

TSQL to obtain the logins provisioned in the SQL Server sysadmin fixed server

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jun 30, 2010.

  1. Anonymous New Member

    In followup to the blog post about SQL Server 2008 Security gotcha: BUILTINAdministrator 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...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2010/06/30/9170.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9170" width="1" height="1">

Share This Page