August 21, 2006 at 10:20 pm
My aspx application gets the following error:
Could not find database ID 25.
Database ID 25 no longer exists in sysdatabases. I am wondering if something needs to be flushed out somehow on our SQL Server. We had deleted some DBs earlier.
August 21, 2006 at 10:49 pm
Restart SQL Server Services. Hopefully this will resolve the issue.
August 22, 2006 at 1:39 pm
Quite likely its the good old refresh in enterprise manager.
I have found with several areas that when a change is made from query analyser, you need to refresh enterprise manager before it recognises them.
Refreshing the database list should solve the issue - I would certainly try that before restarting a service!
August 23, 2006 at 3:12 pm
Actually it happened to be a SQL 2000 bug. I had to drop and recreate the stored proc since it was still trying to reference an old DB ID.
Related articles:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_2d4j.asp
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;834688
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply