Viewing 3 posts - 1 through 3 (of 3 total)
The two databases (old and new) are on the same server.
The recovery model is always simple (and any problem here would result in high disk activity).
There is no...
May 31, 2006 at 2:30 am
#640847
Thanks, we will look at the locks when next it happens. The other causes (reindexing, stats, growing files) would entail disk activity though, wouldn't they, which is a missing symptom.
May 26, 2006 at 1:47 am
#640240
There are no inline functions. We even had the problem with a plain "insert into newdb.dbo.table(...) select ... from olddb.dbo.table"
May 25, 2006 at 10:02 am
#640112