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
Printable View
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
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
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