I am attempting to delete from a linked SQL Server 2008 R2 database... I am able to view the rows to be effected, but when I try to run the query I get the error "Could not delete from specified tables"
Am I missing something? Thanks!
Code:
DELETE dbo_OLDDATA.*
FROM dbo_OLDDATA INNER JOIN Disputes ON (dbo_OLDDATA.[Equip Nr] = Disputes.[Equip Nr]) AND (dbo_OLDDATA.[Eq Init] = Disputes.[Eq Init]) AND (dbo_OLDDATA.Terminal = Disputes.Terminal) AND (dbo_OLDDATA.Controller = Disputes.Controller) AND (dbo_OLDDATA.[Report Dt] = Disputes.[Report Dt]);