MS has hinted that the next version of SQL Server, Yukon, will support the CLR and will be programmable using any of the .NET languages. .NET has very strong exception handling which we should be able to take advantage of. Till then, we're stuck with a very primitive exception handling.
-Mike