Actually I got it to work as follows:

DELETE FROM TABLEX

FROM TABLEX INNER JOIN DATABASEZ.DBO.TABLE1 ON TBXRefNo = DBZRefNo

WHERE (DBZRefName = 'XYZ')

Once I added the FROM TABLEX it worked beautifully.

Thanks for...

It seems you were right in the first place.

I just got off the phone with Microsoft and it turns out I cannot "upgrade" 2000 to 2008 with the evaluation copy....

Did you receive any error that said:

"SQL Server 2000 Meta Data Services packages are not supported"

and

"SQL Server 2000 DTS Designer components are required to edit DTS packages"

I get both....

I should not have to check a 2005 to 2008 upgrade, as I never installed 2005.

When I run the upgrade advisor for 2000 to 2008, it shows me that Meta...

I am not updating an evaluation copy. I am updating a registered copy of SQL Server 2000, using an evaluation copy of SQL Server 2008.

I think this is supported.

Joel