Also, run the queries in Query Anayzer with the execution plan (CTRL-K) set. This can help pinpoint how the query is running and any hot spots.

Brian Kelley has a...

How much memory is on the machine? What else is running?

On a 4GB server, I expect SQL to run steady at 1.7GB. On a 2GB machine, I think it's usually...

The suggestions above are great ones. The attach merely picks up the files that are there. If you got one file and not the other, it would error out because...

That's your best option. No "throttle" per se, which is something I've asked for. Send that to sqlwish@microsoft.com and maybe we'll get it some day.

Be sure you test this...

Why do you need to migrate? Can you not rerun the indexingf on the target server?

Hmmm, not sure. Perhaps including the domain name in the user id call? mydomain/myuser?

While there may not be a "query" per se, the idea you have of reading the sysjobschedules in real time is probably what happens. Perhaps there is some "backdoor" approach...

Rollback means it's rolling back. Likely something is stuck. Did you check for blocks?

If KILL doesn't do it, you'd have to do a restart to end the process.

Good idea. I'll add it to the list, not sure when we'll get to it.

You really need an external process that can accept the files and move them into SQL Server. It could run a DTS package, bulk import, simple insert, whatever.

As far as...

Profiler is the best way. Cumbersome and only for point use.

same here, email, not SQL.

, you need to send in the output parameter for it to be output. Otherwise where does the output parameter go? It's not a...

You guys are thinking too hard. It IS possible to attach back the mdf and get it working. It's certainly possible that this will not work, and there may be...

Haven't done much with it. Called in as a consultant to some companies that have used it but cannot restore. Worked with Veritas and sometimes successful.

My 2 cents: Not worth...