Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 login creation

Author  Topic 

priyaram
Yak Posting Veteran

82 Posts

Posted - 2005-06-23 : 14:04:37
is there anyway to find out at what date the user is added to sqlserver database

thanks

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2005-06-23 : 14:11:23
you could try this:

--login create date
select name, createDate from master..sysLogins where name = 'sa'

--db user create date
select name, createDate from sysUsers where name = 'db_owner'

Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -