Post reply

Issue with function/subquery

  • June 27, 2007 at 3:26 pm

    #117237

    I'm getting this error

    Server: Msg 913, Level 16, State 8, Line 1

    Could not find database ID 102. Database may not be activated yet or may be in transition

    When trying to run a query using a function.

    The inside query dosen't return any rows. Could that have something to do with it?

    I don't have a DBID of 102..

     

    Thanks

    Susan

     

  • June 28, 2007 at 11:49 am

    #715938

    hi,

    can you post your script or

     get the latest service pack

    http://support.microsoft.com/kb/834688

    Everything you can imagine is real.

  • June 28, 2007 at 3:22 pm

    #716000

    the content of your function maybe refering to a database that either does not exists or is not online. Can you post the function Definition ?


    * Noel

  • June 28, 2007 at 4:29 pm

    #716016

    This is a link to that specific issue and the hotfix.

    http://support.microsoft.com/kb/834688

    -SQLBill

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply