Member Avatar for Tess James

Hi

am using sql server 2005..
I hav a query like this.

create PROCEDURE [dbo].[csp_UpdateAutoPart]
(
	 @Code NVARCHAR(6)
	,@Quantity INT
	,@UnitPrice DECIMAL
)
AS
BEGIN
	

	-- Update the autopart details
	UPDATE	 dbo.AutoPart 
	SET		 dbo.AutoPart.Quantity   =   @Quantity 
		    ,dbo.AutoPart.UnitPrice =   @UnitPrice
	WHERE	 dbo.AutoPart.Code       =   @Code

end

While executing it, almost 32 rows are getting updated and an error "Msg 217, Level 16, State 1, Procedure csp_UpdateAutoParts, Line 45
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
" also is displayed

  • 2 Contributors
  • 3 Replies
  • 98 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for Ramy Mahrous

Do you have any triggers on those tables?

Member Avatar for Tess James

Nopes :(

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.