I have a C# assembly that returns a string. I created an SP to call this assembly and it works. But when i try to assign the return value to a variable it does not work. Here is my SP: ALTER PROCEDURE GetDemoPass (@newpass nvarchar(max), @suppliedSalt nvarchar(max)) AS EXTERNAL NAME Salt.[Salt2.SQLSalt].setEncPassword go
when i do an exec on the stored procedure the value is returned but when i try to do something like this: EXEC @salt = dbo.[GetDemoPass] N'Test', N'Test'
The value isn't held in @salt. Is there something simple i am missing?