Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2008-02-19 : 15:46:16
|
| In SQL Server 2000:Can we schedule a trace using SQL Profiler to run at a specific time. Thanks! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-19 : 15:53:56
|
| Check this one:http://www.sql-server-performance.com/tips/sql_server_profiler_tips_p1.aspx |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-19 : 15:57:26
|
| http://support.microsoft.com/kb/258990 |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-02-19 : 16:39:55
|
quote:
Originally posted by sodeep
http://support.microsoft.com/kb/258990
When I ran the script in sql query analyser, I got the below errors. Thx. Could not find stored procedure 'xp_trace_addnewqueue'.Could not find stored procedure 'xp_trace_seteventclassrequired'.Could not find stored procedure 'xp_trace_settextfilter'.Could not find stored procedure 'xp_trace_setqueuedestination'.Could not find stored procedure 'xp_trace_startconsumer'. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 23:01:54
|
| Did you run under master db? |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-02-25 : 11:25:22
|
quote:
Originally posted by rmiao
Did you run under master db?
Yes, I ran from master db in query analyser. Thanks! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-25 : 15:24:22
|
| Checked master..sysobjects? |
|
|
|
|
|
|
Schedule a trace with SQL profiler