In the last week, a stored procedure that updates a table used for populating our websites, has lost code for various columns, causing several of our Euro Websites to fall over! I can't figure out why, how, when..in other words I am lost. No-one has changed the sp since it was created, but out of the blue, update statements etc for several columns went missing. Is there a known bug/problem that anyone knows about that could cause this?
-
-
I don't think that looking for bugs in SQL Server engine have any perspective.
It is more likely that input data somehow became corrupted. Or your stored procedures don't use transactions correctly, so a single failure caused data corruption. -
It's not data corruption, but actual code being lost. I have to re-add code that was in the stored proc, that is not right. This is a stable stored proc that has been in use for months, but out of the blue loses bit of information.Originally posted by almazComment
-
So... your stored procedure just lost several SQL statements? So that part of the stored procedure exists, but some of SQL statements are lost? It is much more likely to be a human factor.Originally posted by Koretex
To be sure that your DB objects are consistent, try running DBCC CHECKDBComment
-
Yep that's exactly it, several of the sql statements were lost, but some still there. It is not possible that it's human factor. Ran checks and all objects are consistent with no other errors. :SOriginally posted by almaz
Thanks for the help!Comment
Comment