Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-11-11
2
Medium Priority
?
260 Views
Last Modified: 2013-11-12
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,,,
0
Comment
Question by:ethar1
2 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 2000 total points
ID: 39641503
DELETE needs to be DELETE FROM
0
 

Author Comment

by:ethar1
ID: 39642335
same
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question