I do not think this is possible, but my boss wants to see the data in a trigger. I know when you insert data it is kept in the cache as inserted. And I believe this kept in a temp table in tempDB. But I believe it is only kept while the session is alive. However, I see the tables in there and every time I do an insert it creates another one. If anyone knows how I can see the data if that is possible. Please elt me know.