While linking servers are not ideal and most likely not the most efficient way of gathering data. If you use a login with minimal security rights to create the connection...

have you tried to do this on another server with more memory to test if the error is correct?

it should be noted the sql server DTS will sometimes change the metadata of a table. In other words if you have a numeric field Like (numeric (11,2)) when the...

happens a lot.

It is most likely trying to update a the row that was inserted with in the same transaction as the insert. Which will not work. The row...

a couple silly questions come to mind.

Does the server meet the minimum requirements?

Were you able to open the manager after you installed SQL 2000 but before you applied the service...

Have you tried to reboot the server itself. I have hit this when the connection between the domain and the server has failed. (can happen for so many reasons). Rebooting...

This is because the SQL Server service is started and once it is started it starts the recovery of the databases. The databases are a part of SQL Server but...

if all you need to do is register the DLL you will want to run REGSVR32.exe

You can open the Run cmd box from the start menu then type in regsvr32...

depending on everything the DTS package is doing you may need to be an owner of the database or a part of the SQL system administrators role. If you use...

I would bet if you open the DTS package the Connection String is still pointing to the other server. Just a guess.

Perhaps I am not understanding but you could just join the tables

SELECT [Post_ID] ,[Post_Title]

[Post_Reply_ID],[Reply_Title], ....

FROM [Cfamla].[dbo].[Post_Detail]

INNER JOIN [Cfamla].[dbo].[Post_Reply]

ON [Cfamla].[dbo].[Post_Reply].[Post_ID] = [Cfamla].[dbo].[Post_Detail].[Post_ID]

have you checked permissions or tried recreating the CUBE?

Does MSDB grow everytime you fail over?

Great but from the error message it looks like it was failing because the user scook did not have the proper permissions. This is typical if you have permissions to...

Using EXISTS and NOT EXISTS should be more like this (I Agree you will most likely want to use Not IN but for arguments sake)--->

USE NORTHWIND

GO

DELETE FROM [Order Details] WHERE...