>>Check DEALLOCATE command in BOL.
>>
>>DEALLOCATE @MyCursor
>
>Do you know if this will trigger another error if the cursor does not exist?
Do you mean you would try to deallocate cursor that didn't exist? Let me try, though you can always use TRY/CATCH in 2005.
Well, it did produce an error if the variable was not declared:
Must declare the scalar variable "@myCursor".
If it's not broken, fix it until it is.
My Blog