Delete row from local after drop field from remote ; tsql dosnt work

Dear all ,
Need Drop field from Remote Database then delete field reference from Local Database.

I try this:
alter Table Remote.dbo.AAAATESTTABLE drop column FieldName28 ;
Delete  ReferenceTable where  FieldID=20094;

 And This:
alter Table Remote.dbo.AAAATESTTABLE drop column FieldName28 ;
Delete  LocalDB.dbo.ReferenceTable where  FieldID=20094;

Both failed to execute delete on ReferenceTable  without any error.
Please Help,,,
ethar1Asked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
DELETE needs to be DELETE FROM
0
 
ethar1Author Commented:
same
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.