Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > capture and sav...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 10998 of 11221
Post > Topic >>

capture and save running sql query to database table (for logging)

by =?ISO-8859-1?Q?Gear=F3id?= <ghealy@[EMAIL PROTECTED] > Apr 24, 2008 at 02:12 AM

Hey,

This may sound odd, but is there anyway to catch the current or just
run query from inside a trigger?  Kinda like how profiler displays the
query just as you've run it, along with all the statistical data...
But I'm just looking to capture the query itself and save it in a
logging table.

I just need to save an executing query in certain circumstances (if
detected an attempted sql injection attack) for logging purposes.

On MS SQL Server 2005

Hope someone can help...

Thanks!

Gear=F3id
 




 6 Posts in Topic:
capture and save running sql query to database table (for loggin
=?ISO-8859-1?Q?Gear=F3id?  2008-04-24 02:12:29 
Re: capture and save running sql query to database table (for lo
"Plamen Ratchev"  2008-04-24 09:30:54 
Re: capture and save running sql query to database table (for
=?ISO-8859-1?Q?Gear=F3id?  2008-04-24 08:14:56 
Re: capture and save running sql query to database table (for lo
"Plamen Ratchev"  2008-04-24 22:34:49 
Re: capture and save running sql query to database table (for lo
"Plamen Ratchev"  2008-04-25 08:59:27 
Re: capture and save running sql query to database table (for
=?ISO-8859-1?Q?Gear=F3id?  2008-05-15 02:49:05 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Wed Jul 9 0:56:00 CDT 2008.