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