Home > Archive > MS SQL Server security > September 2005 > Monitor only reads on just specific table









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Monitor only reads on just specific table
Jim Weiler

2005-09-01, 8:23 pm

Can the profiler be set up to monitor only reads on just a specific
table?
Peter Yang [MSFT]

2005-09-02, 3:23 am

Hello Jim,

This is possible, you could add the following filter:

DatabaseName Like

ObjectName Like

Writes Less than 0

Reads Greater or equal 0

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

====================
====================
=============



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| From: Jim Weiler <jim.weiler@staples.com>
| Subject: Monitor only reads on just specific table
| Date: Thu, 1 Sep 2005 15:59:18 -0400
| Message-ID: <MPG. 1d81260c38d3ad909896
80@msnews.microsoft.com>
| Organization: Staples
| MIME-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-15"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: MicroPlanet Gravity v2.60
| Newsgroups: microsoft.public.sqlserver.security
| NNTP-Posting-Host: 66.181.92.2
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.security:5925
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| Can the profiler be set up to monitor only reads on just a specific
| table?
|

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com