Home Forums SQL Server 2005 T-SQL (SS2K5) How to get the actual query text being fired for a particular operation. I'm trying to implement a trigger on a table where i need to store the query also. RE: How to get the actual query text being fired for a particular operation. I'm trying to implement a trigger on a table where i need to store the query also.

  • January 6, 2009 at 4:02 am

    #921656

    sinureddi (1/6/2009)

    But, can DBCC Inputbuffer(SPID) in an inline query?

    No - it just gives you what was sent to the server - I wasn't 100% sure where you were coming from so thought I would mention it just in case! 😀

    Atlantis Interactive - SQL Server Tools
    My blog[/url]
    Why I wrote a sql query analyzer clone