Good information above.

When you fetch data from a cursor, you're grabbing a row. That returns a status code (OK, end of cursor, etc) and you check fetch_status to determine if...

And be sure the SQL Server is running.

I'd also try some pings/odbcpings from the new client to see if it can connect to the server.

check the error log and see what happened, but my guess is that you will have to drop the snapshot and recreate it.

I was going to suggest what Perry mentioned.

Have you tried multiple Windows users?

Thanks for the note.

Were both the Agent service account and SQL Server service account on the same domain?

I'd pull out a sample of the strange rows, and then convert each byte to its ASCII value. From there you might see some pattern that is causing issues and...

Kevin,

Agree with you here, but we're human and fallible. We make mistakes, sometimes we're malicious, though I hope we're more often respectful of others.

If inventory is an issue, I might do it the way you have listed, but do you not backorder things?

If there's an issue with payment do you want to delete...

Using this?

http://www.microsoft.com/downloads/details.aspx?familyid=31711D5D-725C-4AFA-9D65-E4465CDFF1E7&displaylang=en

I think detach/attach would have been the easy thing to do here.

I'm not sure what you can do now. Can you access the database? Is it online?

I think that there...

Doesn't matter. Just get them both done.

Do you want to pull those records with multiple updates as all the updates or just the last one?

Other than Jack's suggestion, I'd be sure you have things indexed to pull the data. If there is a lot of data, you might cover the query.

It sounds like they don't like Database Mail for some reason. While I'm not sure it's a high volume robust solution for mailing, that doesn't mean it won't work for...

SQL Writer is used to write to the disk.

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlwriter.mspx

It looks like you've changed permissions or service accounts somehow. If you change them, you should always do so in the Configuration...