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...

If you are sticking with SQL2K Std, then RAM isn't an issue. You can only use 2GB, so I'd go with 3 or 4GB for the server to give the...

Is there a question here

Does a WHERE clause not handle this for you with one of the effective dates? Seems like you are...

What's weird? Do you have long strings in there?

I don't think that osql will produce an easily readable format. It's designed to retrieve the data, but not for something like...

No, you would need to use patindex/charindex to get the positions and then substring to find the data. You are dealing with a string here, not a function call or...

They are stored in msdb. You can restore a previous backup of MSDE and get the information from sysjobs and sysjobsteps.

Note: You do not need to overwrite msdb, nor is...

It does impede point in time recovery, but it does allow recovery to the last transaction log as well as recovery afterwards.

Perhaps you might describe your problem as you seem...

If you read the entry, it allow recovery while increasing performance during bulk loads. There are some limitations in how the data is recovered, but assuming you do not fail...