found this in one of the post . see below.

1. Open database mail configuration wizard.

2. Select view or change system parameters option

3. set the "Account retry attempts" to 0...

Very good article. How about running the VBS file using windows Task scheduler. ?

I'm using SQL Server 2000 . What is the best way to handle DML statement exceptions in stored proc. ?

Thank You.

I have intentionally included a failed insert statement and then tried to catch the raiseerror message from asp.net application per your instructions.

When I execute the...