Getting data about users that make logon to sql server

Discussion in 'microsoft.public.sqlserver.ce' started by AMOS, Jul 16, 2009.

  1. AMOS

    AMOS Guest

    Hello everybody

    I've to write a procedure that retrieves the
    login times of a specified user and an indication
    if he is in a login status

    I would like to know Which procedures/functions/views
    I can use/query in order to get such information.

    This information will help me to process the appropriate
    data in my procedure

    Thank you
    Amos
     
    AMOS, Jul 16, 2009
    #1
    1. Advertisements

  2. Hi,
    I'm not sure if you are aware that this newsgroup is dedicated to SQL Server
    Compact, not the full editions of SQL Server (Enterprise, Standard,
    Workgroup, ...).

    SQL Compact doesn't have the notion of loging in, since it doesn't run as a
    service, but in-proc with a .NET/.NET CF app. The best way I see to achieve
    what you're looking for would be to add a logging mechanism to your data
    access layer code.

    --

    Alberto Silva
    http://www.moving2u.pt - R&D Manager
    http://msmvps.com/AlbertoSilva - Blog
    Microsoft MVP - Device Application Development


    __________ Information from ESET NOD32 Antivirus, version of virus signature database 4248 (20090716) __________

    The message was checked by ESET NOD32 Antivirus.

    http://www.eset.com
     
    Alberto Silva, MVP, Jul 16, 2009
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.