Derived Query Problem
-
Hi All,
Oftenly I got such errors when executing query i.e. "Could not find database ID 104. Database may not be activated yet or may be in transition." when using derived queries. Any help regarding this matter how to resolve this & what is causing such messages. But these errors are not coming in many cases.
Thanks,
--Govind
-
What is your query...at any rate here's some info from source
Troubleshooting
Error 913
Severity Level 22
Message Text
Could not find database ID %d. Database may not be activated yet or may be in transition.
Explanation
This error can occur if there is a problem with the view resolution process. During execution of various compiled objects in a database that references the database dbid (such as stored procedures and views), it is typical to resolve the dbid with other structures within the database. When a compiled object is first created, the dbid where the object is located is embedded in the compiled code. For example, when a view is accessed or a stored procedure is executed, the rights to access the view or execute the stored procedure are checked.
Action
If the error occurs when a stored procedure or view is accessed, you may be able to correct the problem by simply dropping and re-creating the database object (stored procedure or view).
If this error continues to occur, contact your primary support provider and have the Microsoft® SQL Server™ error log and any additional information relevant to the circumstances when the error occurred available for review.
**ASCII stupid question, get a stupid ANSI !!!** -
Thanks Sushila,
I've found the reason of this problem, actually I'm using a user-defined function in my derived query, also i'm using SP3. This is a bug in SQL2k and it's been resolved in SP4.
Thanks for giving time on my request.
Govind Bhavan.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply