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?
4  1335 
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.
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.
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.
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.
To be sure that your DB objects are consistent, try running DBCC CHECKDB
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.
To be sure that your DB objects are consistent, try running DBCC CHECKDB
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. :S
Thanks for the help!
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Harold |
last post by:
Hi,
I have a question in SQL Server 2K, I use SQL Profile to trace, and
find Stored Procedure was auto recompiled, like this row in the
trace:
SP:Recompile 15 1680 76 2004-02-27 16:01:11.610
...
|
by: Jeager |
last post by:
Why is it, Microsoft manage to write operating systems and office
applications with every bell and whistle facility known to man. Yet,
even after years and years of development they still cannot...
|
by: CR |
last post by:
To check out stored procs that are under VSS control via my client machine
using .NET, I believe I need to change the Options - Database Tools - Server
Explorer - STored Procedures - Enable Version...
|
by: dmalhotr2001 |
last post by:
Hi,
I have an issue with my query.
1. I have 1 stored proc which have execution calls to multiple stored
procs within it.
2. I want to wrap that main stored proc in the transaction and...
|
by: Adam Greifer |
last post by:
Hi!
I'm a newbie at DB2 but have 13 years of SQL Server. I need to convert over
100 SQL Server procs to DB2. I haven't had much luck with the IBM
Integration Toolkit and want to avoid ER/win...
|
by: NWx |
last post by:
Hi,
I write an ASP,NET application who uses SQL Server (MSDE) as Back-end
I'm an experienced developer, but haven't used SQL server before and I need
some help.
Since I don't have full SQL...
|
by: kentk |
last post by:
Is there a difference in how SQL Server 7 and SQL 2000 processes SQL passed
from a program by an ADO command object. Reason I ask is I rewrote a couple
applications a couple years ago were the SQL...
|
by: Andy Jump |
last post by:
Howdy all,
I have a Sql Server Assembly that contains some Clr stored procs for some of
the more complex operations I wish to perform. When the number of these
stored procs is low then the...
|
by: Bogdan |
last post by:
Hi,
I have a stored procedure that uses JOINs to return columns from multiple
tables. I also have another stored proc that that takes a series of params
and updates multiple tables. I used the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
