<div>
exec CHR.CustomerDetails.dbo.sp<wbr />_execute &quot;truncate table Customer&quot;
</div>


<div>
exec CHR.CustomerDetails.dbo.sp<wbr />_execute &quot;truncate table Customer&quot;<br />
<br />
I get this error message <br />
<br />
Procedure expects parameter '@handle' of type 'int'.
</div>


<div>
<div class="content wysiwyg-content">
I need to truncate a table on a different server. &nbsp;I get error message below. &nbsp;Any ideas?<br />
CHR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; - &nbsp;Different server<br />
CustomerDetails &nbsp;- Database<br />
Customer &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; - table to be truncated<br />
<br />
TRUNCATE TABLE &nbsp;CHR.CustomerDetails.dbo.Cu<wbr />stomer<br />
<br />
The object name 'CHR.CustomerDetails.dbo' contains more than the maximum number of prefixes. The maximum is 2.<br />
&nbsp;
</div>
</div>


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.
 

Truncate Table on a different server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.