Post reply

Sql Server Tracing

  • July 29, 2005 at 6:54 am

    #109821

    I have a Login Table in my Database that stores user login id and password  information, rather than creating sql user accounts i am using this approach , so the question is whether or not it is possible to monitor a user's activity based on a particular login id (stored in login table) through SQL Profiler or Server Side Tracing ? please reply soon

  • July 29, 2005 at 7:11 pm

    #578309

    Hi Asad,

    If i understand ur questation and per my knowledge we cannt track the user activity not in sql user accounts. but yes u can track it from ur operating system trace utility.

    hope this helps u

     

    from

    killer

  • July 31, 2005 at 10:09 pm

    #578403

    Hi Killer

    Thanks For answering my question. So according to you , one can not monitor activities of a user other than the sql server account user (the ones that sql server allows to create ) through server side tracing or profiler. You have mentioned Operating system tracing , i'd really appreciate if you elaborate it a bit more or provide me with some urls that might help me out.

    Regards

    Asad

  • August 6, 2005 at 7:36 am

    #580244

    hi asad

    http://www.windowsitpro.com/SQLServer/ Article/ArticleID/8231/8231.html

    or read windows help for system level trace

    from

    kiler

     

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

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