So it's creating the backup, then fails on the copy? I've never had a problem with log shipping, to start with I'd recommend verifying the permissions one more time, making...

Not a C++ guy but wont the hresult give you an error code you can map to an error message?

Andy

You're trying to move logins or database users? Logins are just data in sysxlogins, you can BCP, DTS, or in SQL2K there is even a special DTS task. Users get...

I use @@error when I think I need to, not after every statement. If it's always going to be one record I use output parameters unless Im returning other recordsets...

No idea yet. Couple questions though. Why don't you use a true #temp table rather than creating a permanent table? And if you're just doing a select, why not just...

They havent that I know of. Could you post the first part of the proc?

Andy

I agree that changing things on the subscriber requires extra care, not to be done lightly. Cascading delete seems like a good suggestion for this case. If you enforce the...

SP2 is the most current. Each SP supports all the various editions.

Andy

If you only have a few I'd recommend going with detach/attach. We've got several articles on the site that discuss it and there is code in one (mine of course!)...

It does leave a potential gap. I fall into that category, full every night, then sporadic log backups during the day based on usage. Have to weigh the risk of...

You could instrument all your procedures so that each logs a line to a table as it executes, spid and proc name (and maybe parameters too).

Andy

Could you post the code?

Andy

I havent been able to reproduce. Have you tried profiling to see if you can see when it happens and what is doing it?

Andy

I agree that embedding formatting in the data is a bad idea, just hard to avoid it sometimes. A lot of standard formatting gets thrown away by the browser, you...

Should work. Are you using a named instance for SQL2K? If so you either have to upgrade your clients to MDAC 2.6 or configure an alias using the Client Utility.

Andy