Intercept sql statement

  • Thread starter Thread starter Zabuti Maxim
  • Start date Start date
Z

Zabuti Maxim

Hi,
I need a way to intercept and modify SQL statement with parameters
sent by .NET application. It should be transparently, I mean I don't
want application to be recompiled. Is there any simple way to do this?
Thanks
 
Hi,
I need a way to intercept and modify SQL statement with parameters
sent by .NET application. It should be transparently, I mean I don't
want application to be recompiled. Is there any simple way to do this?
Thanks
Click to expand...

This is one reason stored procedures are sometimes preferred in
applications. You can change the actual queries without recompiling. Sprocs
are also good if you have to change schema.

But I think you want a piece that sits between the actual running of the
query and it being sent from your .NET application. And I don't think that
is possible without altering the database somehow, if at all.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************
 
Back
Top