Executing TRUNCATE TABLE Against a Table on a Remote Server

[bmann]

I am on calphoto server and trying to truncate a table from a linked sql server. I would appreciate anyone's help.

Here is the code(Linked server CALPHOTODOJ):


truncate table CALPHOTODOJ.audit.dbo.status

 

[SQLDenis]

here you go

EXECUTE  CALPHOTODOJ.master.dbo.sp_executesql 	 N'TRUNCATE table audit.dbo.status'

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[bmann]

Thanks SQLDenis. That code works.