Are you being hit by "Parameter sniffing"? Search here for a description of typical problems attributed to this 'feature' and simple solutions to same.

interesting that "What does @@total_write in SQL Server 2005?"

has an answer that refers to

Explanation: The @@total_read function returns the number of disk writes since the SQL Server instance was...

Stats like those quoted may only be an issue in the context of the size and importance of the databases...which you have left out. 2MB not an issue, 2TB welcome...

it may due to persistance...can you convert the #tables into ##tables....There's a practical difference in terms of the length of their existence (scope)...read BOL for details.

the following links may be useful for this exercise....

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=soundex,algo

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13574&SearchTerms=soundex,algo

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=5238&SearchTerms=soundex,algo

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66781&SearchTerms=soundex,algo

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=84806&SearchTerms=soundex,algo

you could call a batch file via xp_cmdshell with contents like

del lockfile.t-3

ren lockfile.t-2 lockfile.t-3

ren lockfile.t-1 lockfile.t-2

ren lockfile.dat lockfile.t-1

This will allow a 3-day archive.

and then start the "locklogging procedure"....all executed once-a-day...

Several of the universities over this side of the pond have formal work-placement programmes as an inbuilt part of the course.  A four year degree course could have 9-15 months...

37.25 hours per week....and after 20years I'm "pacing myself".  The 18/36 hour shifts are long gone and won't be seen again by me.  Work now just pays for "life outside...

Be aware....the original question is not posted honestly.  It is posted solely to generate traffic to the mentioned website....and as such is SPAM. 

My other half used to do day trips to Boston and NewYork for 1 hour lunch meetings....from Dublin, Ireland (3000ml each way).  Now that's been swopped for 3-country day trips...

I'm not educated in this arena....but I'd go looking for items within your application that won't convert/upgrade....ie any char fields over 4000, or text/binary items that need special treatment.  This will...

You really need a holiday....since one sentance is incomplete.

"Both of these members recently passed the

I'm late on this and I apologize. "

I just find it incredible that on a SQL Server community site you would be advertising a product (or service) which has absolutely nothing to do with the objectives of...

"I have received a request from a developer who states "At a minimum it would be nice to run alters, create tables, veiws, stored procedures, drop tables etc...".

I PRESUME you're...

Excellent morning reading...some SPAM...