<div>
Thanks<br />
<br />
Regards<br />
<br />
bibi
</div>


<div>
bibi.<br />
I'm hoping you can help me out by elaborating on dbcc_freeprocache. &nbsp;Which parameters of the command are you using and how did you come to understand this issue that you realized dbcc_freeproccache was the thing to try?<br />
THX.<br />
-Steve
</div>


bibi.
I'm hoping you can help me out by elaborating on dbcc_freeprocache.  Which parameters of the command are you using and how did you come to understand this issue that you realized dbcc_freeproccache was the thing to try?
THX.
-Steve

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Since two days, we receive this error and the report rs isn't available.<br />
<br />
The OLE DB provider &quot;SQLNCLI10&quot; for linked server reported a change in schema version between compile time (&quot;173821624679687&quot;) and run time (&quot;173838804546623&quot;) for table &quot;&quot;dbo&quot;.&quot;TB_IP&quot;&quot;.<br />
<br />
We resolve the problem with the command dbcc_freeprocache.<br />
<br />
Can you tell me if it's possible to resolve this problem with another solution, please?<br />
<br />
Thanks<br />
<br />
Regards<br />
<br />
bibi
</div>
</div>


Hello,

Since two days, we receive this error and the report rs isn't available.

The OLE DB provider "SQLNCLI10" for linked server reported a change in schema version between compile time ("173821624679687") and run time ("173838804546623") for table ""dbo"."TB_IP"".

We resolve the problem with the command dbcc_freeprocache.

Can you tell me if it's possible to resolve this problem with another solution, please?

Thanks

Regards

bibi

What  can occur this error  a change in schema version between compile time

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.