Extended stored procedures triggering

  • Hi,

    Is it possible to 'attach' an extended stored procedure to the execution of a statement? For example, whenever a SELECT query is executed on the CUSTOMER table, I want my extended stored procedure to get executed.

    Thanks,

    Krishnan

  • This was removed by the editor as SPAM

  • Not simply. If you ran it through a middle ware component you could enforce it that way, or you could profile and look for selects that matched your criteria and run your proc.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • quote:


    Not simply. If you ran it through a middle ware component you could enforce it that way, or you could profile and look for selects that matched your criteria and run your proc.


    I am newcomer to SQL server. Hence, I am not fully aware of the possibilities. How do I implement the things that you suggest - middleware components, profiling, etc???

    Thanks,

    Krishnan

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply