Probably a reg entry that you can remove, but I don't know how to do this. Might try a more Windows related site to help here.

I'll ask around.

Check that, it won't get committed until completed. So the entire thing will be noted in the transaction log, even in simple mode and not cleared until it completes.

Simple mode won't help unless you are processing other work. I believe this runs as one transaction, which means it wouldn't get logged until it was completed.

One of our authors, Haidong Ji, has written a little about it. There also was a competition from Microsoft and they provide a free tool to help you migrate:

http://www.microsoft.com/sql/solutions/ssm/ssmav2.mspx

Do you get this same counter in Performance Monitor, or System Monitor? Sounds like your counters might be screwed up.

For the article, create the stored procedure at the bottom, and...

I've heard the same thing. Usually PSS will instruct you to do this under certain circumstances. Not sure why they don't publish those circumstances, but who knows.

If it works for...

All the technology is there. The key is that it doesn't easily integrate.

The master database is found from a path in the services entry. You can correct this if you need to because paths have changed.

I agree with the right tool for the job. The problem with articles like this is that they present themselves as balanced and they are not. And that's poor when...

Thanks and Frank, I can certainly agree. Our agressive, pioneering spirit has served the US well, but it has definitely led to a lack of social graces

Tim,

Assuming you checked that indexes are the same on both. Be sure that someone hasn't dropped one.

I have seen that sometimes you get weird query plans, especially if data if...

Definitely backwards!

You can install the same user/pwd combinations on your db server and it will try those from the remote server first. That's a headache as well.

If you have a small...

I use these guys for my Homeowners association: http://www.websecurestores.com/HostingServers/HostingPlans/tabid/65/Default.aspx

I run a basic with the dot net nuke framework, but they've been good to me. Still not cheap. The problem I...