执行如下truncate语句删除linked server的表会有报错
truncate table Linkserver1.DB1.dbo.Table1;
报错
Cannot find the object “Table1” because it does not exist or you do not have permissions.
解决方法,在linked server上使用sp_executesql即可
exec Linkserver1.DB1.sys.sp_executesql N’truncate table dbo.Table1’;