why cant we wright a trigger on a temp. table?
prakash
Printable View
why cant we wright a trigger on a temp. table?
prakash
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