Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  .NET Inside SQL Server (2005)  Bubble exception from TVF

Author  Topic  Drorsvr Starting Member 1 Post Posted - 2010-02-03 : 10:21:38 Hi, I've created a SQLCLR TVF which using WMI query, connect to target machine (remote or local) and retrieves System drives information. It uses impersonation in order to obtain caller's credential (obviously only Admin role will get to see anything). it all works fine to the point where an exception occurs(e.g - access denied). At this point i would like to bubble the error message and trigger SQL error on the client side. unfortunantly it doesn't work with TVF's. Any ideas how it can be done? Dror