Avatar of ohemaa

asked on 

Truncate Table on a different server

I need to truncate a table on a different server.  I get error message below.  Any ideas?
CHR                     -  Different server
CustomerDetails  - Database
Customer             - table to be truncated

TRUNCATE TABLE  CHR.CustomerDetails.dbo.Customer

The object name 'CHR.CustomerDetails.dbo' contains more than the maximum number of prefixes. The maximum is 2.
Microsoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon