How to use UDT variables in Stored Procedure...  
Author Message
SameerTeni





PostPosted: .NET Framework Data Access and Storage, How to use UDT variables in Stored Procedure... Top

Hello,

I have defined a user ddefined type in C# and DLL is registered with SQL server. I could access defined UDT that in Stored procedure or in SQL query. But when I define stored procedure and tries to execute it, the following error occures -

".NET Framework execution was aborted because of stack overflow."

I have written the following code.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[TempSP]


AS
BEGIN



END

Commented print statements are working fine. Only SQL query is not working in Stored Procedure. If I copy paste this code outside the SP and executed in query analyzer then also it works fine. Only SQL queries are not working.

Thanks in Advance,

Sameer




.NET Development25