Results 1 to 2 of 2

Thread: about temp. tables

  1. #1
    Prakash Guest

    about temp. tables

    why cant we wright a trigger on a temp. table?

    prakash

  2. #2
    Dave Arnold Guest

    about temp. tables (reply)

    Hi,

    I'm not sure, but I think it wouldn't make sense to trigger on a temp table because, temp tables,
    like the name implies are "temporary", they might not always be in existence.
    I believe that the dmbs will clean out the temp tables from the tempdb at certain times. Like
    when you shutdown and restart the server.

    -Dave


    ------------
    Prakash at 3/4/99 10:38:46 AM

    why cant we wright a trigger on a temp. table?

    prakash

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •