December 3, 2001 at 2:27 am
Hi all
Ive spent some time buggering around with profiler under ss2k EE. Basically
I only want to track selects, either embedded in vb type calls etc or
straight from sqlserver. Any ideas on what data column value to
specify?
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
December 3, 2001 at 10:22 am
You'd want the textdata data column, but the T-SQL event stmt starting or completed. These will include other items, but you can filter the result with textdata like 'SELECT%' or whatever criteria you want. If you do '%select%' then you will get 'insert x () select y, z' as well as normal selects.
Steve Jones
December 3, 2001 at 6:28 pm
Steve
Thanks steve, I swear I played around with this and didnt seem to pick up everything.
I will give it another burl.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply