SQL Server 2005 databases aren't backward compatible with SQL Server 2000. You could install SQL Server 2005 Express, attach the database to that, and then perform an object level...

This select

SELECT ',rtrim (isnull(n.Datetime,' ' +

rtrim (isnull(n.NCOLEC,' ' +

rtrim(isnull(n.NTEXT,' ' +

rtrim(isnull(n.FLAG,' FROM...

Based on the errors, it looks like @sql isn't big enough to hold all the text. It looks like it should be, but what do you get if you...

Two ideas:

In the real code, is there anything else on the line with 'GO"? If so, remove it.

Does it complain if the 'GO' is lower case?

Bert - The bottom line here is that if people treated the world as more black and white rather the shades of gray painted here, we would have a...

There's a setting that deals with the concatenation of NULL with any other value.

SET CONCAT_NULL_YIELDS_NULL { ON | OFF }

Setting this differently will, I believe, yield the...

How much memory is in the box? How much memory is SQL Server using? If the backup is using the lion's share of the page buffers, the users may...

If memory serves, it used to be: /n

So, if you go to the linked server, you don't see the connection you're starting from the original server. Sounds like it's having trouble logging in.

Could you post the...

So, did you change the query to use prod.master.dbo.syslogins?

Can you see the connection being made on the linked server? If so, what database is the spid using?

Does the account...

Maybe it's just a typo, but the 4 part name should be:

server.database.owner.table

which I think, in your case would be prod.master.dbo.syslogins.

Is there an error message in the log of either server??

Could you post the code you're running to do the deletes? How much memory does the server have and what is the system paging rate?

Are you converting the dates because you want to match on the date, but the time is immaterial? If so, check out this thread for some ideas on changing...

It's logging everything. Simple mode just means that the log automatically truncates at each checkpoint, when it can be sure the dirty data pages have been written to disk....

OK, no error message. So, when you say 'the proc isn't running any more', what exactly does that mean?

How does the proc get invoked? Can you run it...