Home Forums SQL Server 2005 SQL Server 2005 Strategies Run stored procedure when temp table is created/dropped RE: Run stored procedure when temp table is created/dropped

  • January 22, 2013 at 12:38 pm

    #1579802

    i am wondering if you could put an extended event for CREATE_TABLE on the tempdb?

    I'll grab one of my sample extended events and try it, but it's just an idea for now;

    i'd think that the extended event would be destroyed on start/stop of the server, so you'd need something that keeps adding it back, if an extended event is even allowed.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!