Click here to Skip to main content
15,919,778 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I need to do a script that shows me the users on my sql server.

I have come this far:
SELECT name,type_desc,create_date,modify_date,default_database_name
FROM sys.server_principals
WHERE type in ('g','s')


BUT what i now need is to know who created these users?
Posted
Updated 7-Sep-10 3:27am

1 solution

AFAIK, SQL Server does not keep track of who creates which user accounts.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900