8f852b28   
   From: esquel@sommarskog.se   
      
   Zabuti Maxim (zabutimaxim@gmail.com) writes:   
   > 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?   
      
   So this is a third-party application, that you have no control over?   
   Sure, write your own application that listens on port 1433 decodes   
   the TDS packages (the specification of this protocol is now publicly   
   available) and then sends them to SQL Server. You would also have to   
   handle data sent back from SQL Server.   
      
   I think you would have to be quite desperate to do it.   
      
   However, if you are only looking to improve performance, for instance   
   force parameterisation, you can use plan guides in SQL Server.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)