Running MSDE 2000 SP2 on Windows XP SP3.
I have a T-SQL script that is relatively simple (adding constraints,
inserting rows, etc.) and short (maybe 300 lines, heavily commented).
It's an upgrade script I wrote weeks ago, and has worked fine
everywhere.
After the patch from last Wednesday. "Security Update for SQL Server
2000 Service Pack 4 (KB948110)", I have gotten the following error on
two different machines, using a copy of the script from our source
control that is known to be many weeks old, and to have worked:
Server: Msg 615, Level 21, State 1, Line 1
Could not find database table ID 8, name 'MyDatabase'.
The script gets this error about 75% of the time - and sometimes it
runs fine. When it fails, I cannot locate the exact line of code - it
seems to be random. I've never seen this error message before, and
Google Groups has no hits for "Could not find database table ID".
Google Web has about 15 hits, all of which seem unrelated.
Googling for "KB948110" has led to a handful of people having various
problems with this patch, but not mine. I did notice someone complain
that the patch had been applied to SQL Server 2000 SP3 database when
it should not have. This made me realize that this SP4 patch had been
applied to my MSDE 2000 SP2 database, which I assume it should not
have.
Uninstalling the patch fixed the problem. Interestingly, re-
installing the patch did not bring back the error message.
Some interesting links: http://support.microsoft.com/default...b;en-us;224071 http://simultaneouspancakes.com/Less...nd-sharepoint/ http://blogs.technet.com/sbs/archive...3-servers.aspx
Anyone else seeing this? Anyone know if Microsoft aware of it?
Thanks. 3  6015 
Larry Leonard (La***@definiti vesolutions.com ) writes:
Googling for "KB948110" has led to a handful of people having various
problems with this patch, but not mine. I did notice someone complain
that the patch had been applied to SQL Server 2000 SP3 database when
it should not have. This made me realize that this SP4 patch had been
applied to my MSDE 2000 SP2 database, which I assume it should not
have.
It sounds scary that the hotfix installed despite that you were only on SP2.
Then again, the download pages says "Security Update for SQL Server 2000
Service Pack 4 and MSDE 2000" without any service pack indication for
MSDE. Yet, then again, I don't get less scared if this really means that
the hotfix would install itself on MSDE 2000 RTM if it got the chance.
Uninstalling the patch fixed the problem. Interestingly, re-
installing the patch did not bring back the error message.
You didn't consider installing SP4 while you were at it? :-)
I don't know exactly what is in this hotfix, but SP3 (and SP4 of course)
includes the fix for the Slammer worm, which is far bigger threat than
the issues addressed by this hotfix. And that vulnerability was not in
the engine itself, so may still not have that protection. (Unless you
have previously installed the hotfix for SP2 for Slammer.)
As for the error message, the condition is gone, so it's not easy to
repeat and examine, so I guess that all you can do is to chalk up one
more for the green man in the machine. :-)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
It sounds scary that the hotfix installed despite that you were only on SP2.
Then again, the download pages says "Security Update for SQL Server 2000
Service Pack 4 and MSDE 2000" without any service pack indication for
MSDE.
Well, I finally discovered it has nothing to do with the MS patch – I
“ghosted” an image from April that fails the exact same way.
You didn't consider installing SP4 while you were at it? :-)
If I could move up to SP4, you think I'd still be using 2000 at
all? :-)
As for the error message, the condition is gone, so it's not easy to
repeat and examine, so I guess that all you can do is to chalk up one
more for the green man in the machine. :-)
It's easy to repeat now: it’s happening on five machines, each with
their own MSDE database. I finally tracked it down to the USE
command: these two lines, believe it or not, give me the “Could not
find database table ID #, name 'x'” error:
USE MyDatabase
DECLARE @X INT
Fortunately, I can re-write my short script to use the
database.dbo.ta ble syntax.
This ( http://www.eggheadcafe.com/software/...base-name.aspx
) is exactly what I’m experiencing, but all our collations are set to
the default of LATIN1_GENERAL_ CP1_CI_AS, so I don’t think it’s a
collation problem.
I wonder if something’s gang agley in the master database? When I say
“SELECT name FROM sysdatabases”, I see all my databases, so why
doesn’t USE see them? How hard is it to rebuild master?
Larry Leonard (La************ ***@gmail.com) writes:
>It sounds scary that the hotfix installed despite that you were only on
SP2. Then again, the download pages says "Security Update for SQL
Server 2000 Service Pack 4 and MSDE 2000" without any service pack
indication for MSDE.
Well, I finally discovered it has nothing to do with the MS patch – I
"ghosted" an image from April that fails the exact same way.
If I understand this right, you get this error on MSDE 2000 SP2, without
the security fix as well?
This ( http://www.eggheadcafe.com/software/...base-name.aspx
) is exactly what I'm experiencing, but all our collations are set to
the default of LATIN1_GENERAL_ CP1_CI_AS, so I don't think it's a
collation problem.
I cannot see any connection between your error and that link. When I think
of it, the error message is:
Server: Msg 615, Level 21, State 1, Line 1
Could not find database table ID 8, name 'MyDatabase'.
Database table 8 is sysfiles1. Let's see, is the database set to auto-close?
If it is, SQL Server would have to open it, and to find all files, in
needs to look in one of sysfiles and sysfiles1, to find any secondary
files.
Notice that the severity of the level is 21, which is a very high level.
Books Online says:
Severity Level 21: SQL Server Fatal Error in Database (dbid) Processes
These messages indicate that you have encountered a problem that
affects all processes in the current database; however, it is unlikely
that the database itself has been damaged.
So this is an error that "should not occur". I would suspect a bug that
thrashes an internal memory or somesuch.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Don Isgitt |
last post by:
Environment: Server running Redhat 3.2.3-20 on quad Xeon 2.4
Postgresql 7.4 compiled from source (gcc 3.2.3)
Application written in Perl (5.8.0) using Tk,
DBI and DBD
Client accessing DB using ODBC (7.03.02) from
Win XP box
Sample of errors follows:
2004-04-26 10:15:38 LOG: 00000: connection authorized:
user=djisgitt database=gds2
|
by: jim |
last post by:
I'm trying to import a 625MB, tab-delimited .txt file into Access, but
I keep receiving the following error after several minutes of what seem
to be noble attempts by Access to render the data:
The Microsoft Jet database engine could not find the object ". make
sure the object exists and that you spell its name and path name
correctly.
Does anyone have any idea of what this object is (".)? Because it's
nonspecific, I'm not sure if...
|
by: lawrence k |
last post by:
I've a jpeg image that is 514k, which doesn't strike me as very large.
Yet I'm running out of error when I try to resize it:
Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to
allocate 12288 bytes) in
/home/httpd/vhosts/monkeyclaus.org/httpdocs/media/audio/pdsIncludes/resizeImageToSquare.php
on line 82
How can I protect against out-of-memory errors?
|
by: dave |
last post by:
Hi,
I have searched for the answer for this error message without
success. I have seen the question many times though:)
I create an ASP.NET project (VS 2005, C#), and use a very simple .mdf
file (which I can provide if necessary). I use 'Add new Item' and
pick 'DataSet'. I believe this creates a TypedDataSet, CORRECT? I
take all the defaults as far as Insert, and I pick the advanced tab
and ask for Update Statements and Delete...
|
by: Twanne |
last post by:
Hi,
I've got a table called Aerosol and a table called LinkTabel.
Now I do an update to a table from an excell sheet, this table is called ExportAerosol. So far so good, the import works perfect.
Now when I want to transfer the data from the ExportAerosol table to the Aerosol table I have to make a unique key. I do this by adding a string to another key. Now there is no problem when I update the Aerosol table. It adds the values I...
| | |
by: rangi500 |
last post by:
Hello,
We've recently started getting errors like this:
Last error:
ERROR: could not write to hash-join temporary file: No space left on device
But there is plenty of space on the all the drives.
Does anyone know what might be causing this?
|
by: fniles |
last post by:
One of our application uses VB6 and Access97 database. Another application
uses VB.NET 2005.
This morning for about 15 seconds when the application tries to read either
a query or a table from the database, in in both VB6 and VB.NET
applications, I got the error "The Microsoft Jet database engine cannot find
the input table or query 'myTable'. Make sure it exists and that its name
is spelled correctly." Also, I got the error "The...
|
by: Chuckk Hubbard |
last post by:
The docs say to try to discover the URI on my own if this happens.
Could I get a hand doing that?
This isn't just something I want to solve on my machine, e.g. by
changing my network setup or what not; this is a program I hope to
distribute and I hope my users can avoid having to deal with this,
because I suspect they won't.
Thankye.
Here's what I typed and what I got:
|
by: Chuckk Hubbard |
last post by:
OK, I think I have it. The Manual says to start a Name Server "using
the ns command", and I figured out that means using the pyro-ns
script.
On Mon, Nov 10, 2008 at 10:49 AM, Chuckk Hubbard
<badmuthahubbard@gmail.comwrote:
--
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
