Hello,

I am learning how to create CLR stored procedures in VB 2005 for SQL Server 2005, and I have created them well enough, but in all of the tutorials I have been finding they are all consumed using T-SQL. Is it possible to use a CLR stored procedure directly from an application? If not, I know how to execute the T-SQL using SSMS (SQL Server Management Studio), but not how to do it from code. Can someone help me out with how that would be done, if the CLR sproc can't be called directly?

Also, in my clr sproc, I send a uniqueidentifier back thru a pipe since Return won't send it. If I do have to use T-SQL to execute the CLR sproc, will it still return the uniqueidentifier? If it depends on how I make my t-sql command, then how can I make it return the uniqueidentifier?

Sorry to unload so many questions at once. Thank you for your help.