SYSOBJECTS System table has a CrtDate (create date) column which should meet your needs. Be careful you only search for user tables.

I think you meant to use sp_MSForEachDB instead of sp_MSForEachTable

Are you inserting all 3 million records into a temp table?

If so, how about inserting ONLY records into a temp table having count(*) > 1 (after the grouping on the...

You pretty much answered this yourself. The query inside your EXISTS statement alone is returning a resultset, which means that your EXISTS statement will always evaluate to be...

Also, after caching has been turned off, you should restart SQL Mail by executing xp_stopmail then xp_startmail.

I experienced the same problem on a new development machine of ours. The solution was to turn OFF caching on the outlook client. Also, it wasn't just the...

Can you try turning off caching on your outlook client?