Re: User creation date

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 05/26/04 

Date: Tue, 25 May 2004 18:14:12 -0400

Are you talking about a USER or a LOGIN? Since you mentioned syslogins I
assume you mean Login? If so then the CreateDate in syslogins is what your
after. If your looking for a USER then use the CreateDate in the
appropriate sysusers table. Try BooksOnLine for more details. 

-- 
Andrew J. Kelly
SQL Server MVP
"Lynn" <anonymous@discussions.microsoft.com> wrote in message
news:62570008-D8D4-4DCC-8FFB-E0FDEA290187@microsoft.com...
> Hi,
>
> How can I find the user creation date in the SQL instance?  Is xdate1 in
syslogins is the user creation date?
>
> Thanks.
> Lynn
>

Relevant Pages

  • Re: EM does not display Login Name
    ... The syslogins table and the sysusers table will be ... then the login name is null and nothing will display ... >mentioned sp's to add users to this database. ... >entering details passed through to the script. ...
    (microsoft.public.sqlserver.security)
  • Re: Tracing sql server user logins
    ... Actually updatedate in syslogins is used to record the last ... SQL Logins, changed default database, etc. ... the last login. ...
    (microsoft.public.sqlserver.security)
  • Re: Is there a way to find out which login who created a login?
    ... SQL Server will not store those information Only Login created date will ... be available in syslogins table ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • User creation date
    ... How can I find the user creation date in the SQL instance? ... Is xdate1 in syslogins is the user creation date? ...
    (microsoft.public.sqlserver.security)