Re: ASP.NET SQL Processes



SQL server doesn't keep any processes attached to the application. It just
serves data access requests select/update/insert/delete. It doesn't care of
the application errors.

Eliyahu

"Tim::.." <Tim@xxxxxxxxxxxxxxxxx> wrote in message
news:BFC1082A-7060-4B53-9FD9-3EF188D5E7C1@xxxxxxxxxxxxxxxx
> Can someone please tell me how I get around this???
>
> I have an ASP.NET web application that uses an SQL 2000 database for the
> majority of the web sites content... If the application comes up with an
> error the process on the SQL server remains alive. How do I make sure that
> the process is killed on the SQL server even if there is an error???
>
> I guess you use "TRY" but am new to asp.net programming and would
appritiate
> any examples or suggestions...
>
> Thanks


.