Very helpful thank you, and excellent info from one so young!  Now we know we really have to watch our backs Ms. Ahrens.  As always, my searching skills w/ BOL...

Sometimes these questions are best thought of as "open book quizes".  I welcome the more abscure Admin questions as a chance to hear about something I may not hit in...

great info, thanks so much for the reply.

- jh

[newbie's rock too!]

:~)

thanks gang!

happy new year

Skål - jh

Too funny that my question garnered absolutely no response. But a dot got three.

Guess they weren't kidding that puncuation is important! 🙂

jh

If you can capture the @@ERROR value immediately after the step you wnat to trap

you can test that and then use a "goto" label to jump where you want...

Reading the "SQL Black Belt" in SQL Server Mag. has helped me alot. Also if you can get access or a snapshot of a real -life database and then...