I have created the stored procedure and I want to handle the error like
Create Procedure MytablePro
as
select fld1, fld2 from mytable
GO
EXEC MytablePro
if some one changed the table name at the back end then I have to give
problem error but right now when procedure execute it gave me like this
Server: Msg 208, Level 16, State 1, Procedure SPSelectBedRoom_New, Line 15
Invalid object name 'mytable'.
I want to make it proper way... can any one help... what sort of amendament
in the stored procedure.
Thanks
Hari Prasad - 25 Jul 2005 20:26 GMT
AFAIK, You cant do that.
Thanks
Hari
SQL Server MVP
>I have created the stored procedure and I want to handle the error like
>
[quoted text clipped - 14 lines]
>
> Thanks
Roy - 28 Jul 2005 05:55 GMT
If I can't do then what master..sysmessages table represent?
> AFAIK, You cant do that.
>
[quoted text clipped - 20 lines]
> >
> > Thanks