Monday, 15 March 2010

tsql - How do I truncate a table via linked server using a synonym for the table name? -



tsql - How do I truncate a table via linked server using a synonym for the table name? -

i know can following:

exec server_name.dbname.sys.sp_executesql n'truncate table dbo.table_name'

but if want utilize synonym table?

i'm on server1 , want truncate table on server2 using synonym table name.

is possible?

according this blog post cannot, provides work around.

sql-server tsql linked-server synonym sp-executesql

No comments:

Post a Comment