February 2, 2011 at 11:01 am
Does anyone know if there is a way to query anything that will show when a user login was created? Trying to determine when a user was deleted and added back to a database.
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/
February 2, 2011 at 12:06 pm
figuring out when the user was deleted will be a hard job.
Regarding when a user has been added to a database:
maybe this query can help out.
use yourdb
select *
from sysusers
order by name ;
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply