March 21, 2011 at 12:27 pm
Hi Guys,
I see that SQL Server 2008 has 2 ways to find Login Creation Date:
select *
from sys.syslogins
select *
from sys.server_principals
Both of them displays login-creation date under, CreationDate column.
But i do not find anyway for SQL-Login-Deletion Date. Both above Tables/Views do not have that info.
Can anyone tell me how to find such info from SQL Server...!!
Recently we came accross issue, in which someone deleted existing SQL Server Login.
So i need to find who deleted that login...As Login has already been deleted, running SQLProfiler(Trace) will not help us...
Is there any System Tables, Views..i can use to find this info...!!!
Thanks & Appreciate in advance.
Hit
March 21, 2011 at 1:19 pm
I think unless you were able to capture this via trace you are pretty much outta luck. Pretty much impossible to find the date that something that no longer exists was deleted unless it was logged somewhere. Even harder will be to tell you deleted something that no longer exists. About the best you might be able to find is when it was deleted digging through backups. Really it seems like it doesn't much matter who did it unless their was potential malicious intent that you are trying to prove.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply