Posted by: smoothcriminal August 17, 2008
Login in to Rate this Post:
0 
? 
?
Why do you have to put the results in Temp table taking TEMPDB resources. Remember SQL server 2005 uses lot of TempDB resources than SQL 2000. Just use Export/Import wizard and schedule it if you like to.