Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Emanuele Garuglieri
Starting Member
3 Posts |
 Posted - 2007-02-07 : 05:14:03
|
| Hi to everyone!This is my first topic in this forum and i have a very good question for you!I have to monitoring a single set of tables (not the entire DB) so i want to know:how can i set the SQL-Profile for this purpose??Thanks very much!Emanuele Garuglieri |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-07 : 05:23:55
|
| Welcome to the Forum, Emanuele!You can set filter criteria to watch set of tables:1. Click On the File, Open, Trace File2.Select trace file to open.3. In the Trace Properties dialog box, click the Filters tab.4. In the Trace event criteria list, click on Object Name5. Enter a value in the field that appears beneath the LIKE criteriaHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Emanuele Garuglieri
Starting Member
3 Posts |
Posted - 2007-02-07 : 05:40:38
|
| Thank you very much!So the object name rappresent the name of the table!Usefull to know! ;-)ByeEmanuele Garuglieri |
|
|
|
|
|
|
SQL Profiler and table