Post reply

System Tables

  • May 16, 2007 at 3:31 am

    #68410

    Hi,

    I need to write a query that will display the following items:

    DB_Username, Number of Logons, OS_Username and the Return_Code eg.(Successful Logon)

    Does anyone perhaps know where I can get this information from in the system tables?

     

    Regards

    IC

  • May 16, 2007 at 5:16 am

    #706725

    Select SUSER_SNAME() AS SECUREUSERNAME, SUSER_SID() AS SECUREUSERID, HOST_NAME() AS HOSTNAME, HOST_ID() AS HOSTID,

    DB_ID() AS DBID, DB_NAME() AS DBNAME... Try this if you are using SQL2k. May be it works in SQL2K5 too...

    Regards,
    Genie Cool

  • May 16, 2007 at 7:10 am

    #706765

    Some of that information is available from sys.syslogins. I think the more dynamic stuff, like the number of logons, isn't going to be there. You may need to set up some sort of monitoring scheme to catch that information.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply