Intercept sql statement

[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

 

[Gregory A. Beamer]

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

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! |
*******************************************