November 3, 2011 at 10:30 am
I can setup a profiler (SQL Server 2000) to trace the SQL's for specific databases. But let's say if I Setup a profile on DB_1 and if a select happens from the contect of DB_2 Use DB_2, then my trace does not capture that SQL's. Does anyone have any idea how to setup a trace like that?
1. Setup profiler to trace specificly on any sql's on DB_1.
2. A process using the database called DB_2 running a select from a view or a strored proc which is
Select first_name, last_name from DB_1.dbo.CUSTOMER
My question is how do I setup a trace for capturing the sql's running against DB_1 database from any context?
Thanks in advance for your ideas.
November 3, 2011 at 9:28 pm
Have 2 traces, one filtered on database name and the other one on textdata column.
1. DatabaseName Like DB_1
2. TextData Like %DB_1%
November 7, 2011 at 3:02 pm
Thanks Nan82.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy