I’m trying to truncate a table on a linked server. I’ve given myself all possible permissions on the linked server. I can run: SELECT * FROM linkedServer.import.dbo.SafetyStockTime But when I run: TRUNCATE TABLE linkedServer.import.dbo.SafetyStockTime I get the error: Cannot find the object "SafetyStockTime" because it does not exist or you do not have permissions. So I know it exists, and I’ve assigned myself all possible permissions. Any help as to what I'm missing?? Thanks
You can't truncate a table over a linked server since truncate is DDL and not DML. You'll need to use delete instead or connect to the server directly rather than through the linked server.
truncate a table on a linked server
Posted - 10/17/2012 : 16:21:56
