Hi,

I  have four different databases and I need to collect different types of trace event for them.
For example DB1 I just need to collect login/logout event.
For DB2 I need to collect some other events and so on.

Whether I should run a single trace and collect all the data or multiple trace for each database using filter.
Which approach will be better?

Thanks in Advance
Pushkar

Depends.  I would probably do a trace like this into a table, then you can
filter out the events/databases that you need, and you can put them together
if you want to see everything in order.

I  have four different databases and I need to collect different types of
trace event for them.
For example DB1 I just need to collect login/logout event.
For DB2 I need to collect some other events and so on.

Whether I should run a single trace and collect all the data or multiple
trace for each database using filter.
Which approach will be better?

Thanks in Advance
Pushkar

Alter table / update... set - strange problem
Newbee question about permissions and sp_OACreate
Stored Procs vs VIEWS: Seeking Comparison
How to find gaps in sequential key
boolean programming