December 11, 2007 at 10:58 am
I am having an issue with a POS (Point pf Sale) Database, which is not allowing me to enter new serial numbers for an Item into a table...
There is another program which is used to manipulate the Database, but the error message that I am getting seems to be SQL related...
the message is:
text for "DF_Serial_HQID" is missing from syscomments. The object must be dropped and recreated before it can be used.
I'm at the just bought SQL for dummies point in learning SQL, but the error message is pointing me to an SQL Related Problem...am I off?
Thank You
December 11, 2007 at 11:10 am
It sounds like corruption or perhaps a problem with the syscomments table.
My guess is DF_Serial_HQID" is a default on the table. If you check the table in SSMS, look for a default defined on one of the tables. Or perhaps it's a function that populates a default.
In any case, you can drop this from the table, then recreate a new one. I might go back to the vendor or a backup to get the code.
Don't ever mess with syscomments.
January 9, 2008 at 10:24 pm
I have a doubt, What kind of problems can be solved by updating the statistics of the table?
January 9, 2008 at 11:48 pm
Is this related to the original question? If so, then none. Stats aren't going to help when stuff is missing from a table (which was the original problem)
If not (and you should rather create a seperate thread) then updating stats can lead to a more optimal execution plan been picked by the optimiser. Especially true on large tables where the stats can fairly easily get out of date.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply