February 13, 2019 at 7:14 am
I tried to searc for the answer but have come up empty. COuld someone tell me what datatype is being used in this error message for the times (assumed to be a date time?
Error Message: The OLE DB provider "SQLDBPROV" for linked server "SSQLALPHA"
reported a change in schema version between compile time ("186839690094804") and run time ("186852574981615")
for table ""ALPHA17"."dbo"."TTVA"".
Thank you!
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
February 13, 2019 at 8:48 am
paging @gilamonster
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
February 13, 2019 at 9:13 am
I think those numbers refer to the schema versions, not the compile time and run time.
John
February 13, 2019 at 10:19 am
MothInTheMachine - Wednesday, February 13, 2019 7:14 AMI tried to searc for the answer but have come up empty. COuld someone tell me what datatype is being used in this error message for the times (assumed to be a date time?Error Message: The OLE DB provider "SQLDBPROV" for linked server "SSQLALPHA"
reported a change in schema version between compile time ("186839690094804") and run time ("186852574981615")
for table ""ALPHA17"."dbo"."TTVA"".Thank you!
Bottom line here, is, a schema change occurred, in the timeframe specified, and that kind of thing can and will cause problems.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
February 14, 2019 at 1:47 am
thing with these "schema changes" is that many times they do not affect the code - one possible way to avoid this error in some cases is to set "lazy schema validation" on your linked server to true.
Where the schema change breaks the code it will still be caught.
February 14, 2019 at 6:32 am
All good information, and appreciated but still don't know what these digits represent.
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
February 14, 2019 at 6:42 am
MothInTheMachine - Thursday, February 14, 2019 6:32 AMAll good information, and appreciated but still don't know what these digits represent.
Pretty sure those are schema version numbers. Not much you could probably do with them, either.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply