Post reply

View / Log all queries coming into SQL Server 2000 database

  • November 22, 2004 at 3:55 pm

    #163285

    Hi

    I would like to view all queries coming into my SQL Sever 2000 database, especially failed queries.

    I've spent about 3 hours researching how to do this, scouring forums, and delving into the depths of Enterprise Manager.

    Any help gratefully appreciated (and beers bought for you in the Christchurch area!).

    Kind regards

    Dave

    dave at davemateer.com

  • November 22, 2004 at 3:58 pm

    #531138

    Why don't you just use Profiler and log it to a Database?

    Kindest Regards,

  • November 22, 2004 at 4:35 pm

    #531143

    Trigger - you are a genius.

    Many thanks (beer is on me).

    Regards

    Dave.

  • November 22, 2004 at 5:24 pm

    #531147

    Be careful with Profiler.  Microsoft has stated that they cannot guarantee that all transactions are captured with profiler.  Especially during periods of high activity, some transactions may be lost.  If you are using this for an auditing purpose and need 100% assurance that you are capturing every transaction, it may not be the best course of action.

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

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