dcsimg
Results 1 to 3 of 3

Thread: Cannot run query--referenced object

Hybrid View

  1. #1
    Ali Alhussein Guest

    Cannot run query--referenced object


    Msg 225, Level 16, State 1
    Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.

    can anyone tell me how to solve this problem
    thanks

    Ali

  2. #2
    Gregory Guest

    Cannot run query--referenced object (reply)

    is it a sql query or stroed procedure?
    maybe you just need to re-create stored procedure (recompile)?
    maybe you need to look in query showplan (using set showplan on)?


    ------------
    Ali Alhussein at 4/9/99 9:05:53 AM


    Msg 225, Level 16, State 1
    Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.

    can anyone tell me how to solve this problem
    thanks

    Ali

  3. #3
    Phil Durham Guest

    Cannot run query--referenced object (reply)

    Check out KB article Q140871 it references the Msg.



    ------------
    Ali Alhussein at 4/9/99 9:05:53 AM


    Msg 225, Level 16, State 1
    Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.

    can anyone tell me how to solve this problem
    thanks

    Ali

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •