Unanswered: How to handle schema changed from another server?
I have two SQL Servers 2000 in separate machines. In client server, there are some views reading tables from data server. There is a regular running in data server in which some tables are recreated every two weeks. After regular running, there are error message when I run stored procedures in client server, like,
Server: Msg 7359, Level 16, State 1, Procedure Validation_Proc, Line 16
The OLE DB provider 'SQLOLEDB' reported a schema version for table '"Data"."dbo"."ALL_Store"' that changed between compilation and execution.
OLE DB error trace [Non-interface error: Schema version number changed from compile time (49860953488266905) to run time (49860953488266889) for ProviderName='SQLOLEDB' TableName='"Data"."dbo"."ALL_Store"'.].
The table Data.dbo.ALL_Store is in data server, and stored procedure Validation_Proc is in client server.
It looks like schema issue. Any help will be great appreciated.