How can i watch a table with Select and Update statements

Question

Post reply

How can i watch a table with Select and Update statements

thinknight

SSCrazy

Points: 2068
More actions
December 23, 2008 at 2:17 am

#133291

Hi all,
I want to watch select and update transactions on a table in my database with SQL Profiler. But I could not.
I set databasename but could not found any filter entry named tablename.
waiting for your responses.

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

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

v.belov SSC Veteran Points: 230 More actions · Answer 1

Try add "ObjectID" column in your columns collection in SQL Profiler

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 2

I usually set this kind of filter in the TextData column. I just write the table's name with wildcards at both sides (e.g. %TableName%).

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Paresh Prajapati SSCertifiable Points: 7567 More actions · Answer 3

Use follwing events:

TSQL:

1.SQL:BatchCompleted

2.SQL:BatchStarting

Stored Procedure:

1.RPC Completed

and use following filter

1.Databaseid

2.Loginname

_____________________________________________________________________________________________________________
Paresh Prajapati
➡ +919924626601
http://paresh-sqldba.blogspot.com/[/url]
LinkedIn | Tweet Me | FaceBook | Brijj