truncate a table on a linked server

• herb 25632

  Old Hand

  Points: 333

  More actions

  October 17, 2012 at 2:29 pm

  #283163

  Hi

  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

• herb 25632

  Old Hand

  Points: 333

  More actions

  October 17, 2012 at 2:32 pm

  #1550226

  found answer.

  EXEC Myserver.import.sys.sp_executesql N'TRUNCATE TABLE dbo.SafetyStockTime'