October 5, 2010 at 7:07 am
tt-615680 (10/5/2010)
Grant Fritchey (10/5/2010)
Which, do the same as the default trace or capture RPC:Complete & SQL:BatchComplete events?Yes, I know there are many queries or sysyem sp's that cannot be used in sql 2000.
You didn't answer Grant's question. Which are you looking for a 2000 script for?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2010 at 7:17 am
Grant Fritchey (10/5/2010)
tt-615680 (10/5/2010)
Grant Fritchey (10/5/2010)
Which, do the same as the default trace or capture RPC:Complete & SQL:BatchComplete events?Yes, I know there are many queries or sysyem sp's that cannot be used in sql 2000.
Thank you
Sorry, I'm still confused what you're looking for. Do you want A) a similar listing of events inside of the 2000 trace events that would replicate the default trace for SQL Server 2000, or B) A method of capturing query trace events within SQL Server 2000?
Yes, a similar listing of events inside of the 2000 trace events that would replicate the default trace for SQL Server 2000.
Thank you
October 5, 2010 at 7:22 am
The trace events haven't changed names. To semi-replicate the default trace on SQL 20p00, create a server-side trace with the same events (hint, get profiler to create the script) then create a startup procedure to start the trace whenever SQL starts. You'll also need a job or similar to delete older files.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2010 at 7:29 am
Exactly what Gail says. You can use the list she provided earlier as the basis for your server side trace.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply