Error Capture in Procedure?

Is there anyway to capture and manage errors in a procedure so it can
proceed?
(The server keeps deleting my posts; I hope this one gets through)
TIA!
--
Greg CHi Greg.
There are error handling mechanisms in SQL Server, but they do not allow you
to catch or handle or errors.
Ultimately, you cannot handle all t-sql errors in stored procedures.
There is a good article on the topic here:
http://www.sommarskog.se/
HTH
Regards,
Greg Linwood
SQL Server MVP
"Greg C" <gregc@.austinps.com> wrote in message
news:fT%Mb.16281$RV5.7088@.fe2.texas.rr.com...
> Is there anyway to capture and manage errors in a procedure so it can
> proceed?
> (The server keeps deleting my posts; I hope this one gets through)
> TIA!
> --
> Greg C
>|||Thanks Greg.
--
Greg C
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:#BR3XZk2DHA.2888@.tk2msftngp13.phx.gbl...
> Hi Greg.
> There are error handling mechanisms in SQL Server, but they do not allow
you
> to catch or handle or errors.
> Ultimately, you cannot handle all t-sql errors in stored procedures.
> There is a good article on the topic here:
> http://www.sommarskog.se/
> HTH
> Regards,
> Greg Linwood
> SQL Server MVP
> "Greg C" <gregc@.austinps.com> wrote in message
> news:fT%Mb.16281$RV5.7088@.fe2.texas.rr.com...
> >
> > Is there anyway to capture and manage errors in a procedure so it can
> > proceed?
> >
> > (The server keeps deleting my posts; I hope this one gets through)
> >
> > TIA!
> >
> > --
> >
> > Greg C
> >
> >
>