There are many possible reasons, but the first that pops to my mind is that the original db might be using old execution plans. On 1 of the procs in...

What edition are you working with? It is not installed with Express edition.

SS2008 allows you to pass in a table parameter.

This could mean that Sql server is recovering itself from an error or other issue. In this case it would be recovering from a checkpoint. Check the log files (Sql...