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 |
|
dmaxj
Posting Yak Master
174 Posts |
 Posted - 2010-12-31 : 20:21:29
|
| Is there a way to write SELECT statements to the SQL Server 2005 log?I have looked at TRIGGERS - but have found no concrete evidence?Regards |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2010-12-31 : 21:06:33
|
Check these out (and the referenced links within those)..should give you some ideas. The DMV's already have some stored information available that won't require special loggin. http://www.nigelrivett.net/SQLAdmin/sp_nrInfo.htmlhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99647
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
Write SELECT event to SQL log