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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-13 : 08:15:14
|
| Jose Amado writes "Hi all,I found the way to send a trace to the application log with the command:setqueuedestinationI have done this with SQL 7.0 but i am in a hurry trying to do this with SQL 2K sp3, but i cannot find it,the thing is that I want to audit all activity in a databse, such as index, updates, selects, but i want to see all these events at the applications logs.Thanks for your help.Jose" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-13 : 13:10:46
|
| Wouldn't the application log fill up rather quickly? Why not save the results to a SQL table so that you can then analyze the results easily with T-SQL?Tara |
 |
|
|
|
|
|
send to the application log a trace