Problem in update query

[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

[Ramy Mahrous]

Do you have any triggers on those tables?

[Tess James]

Nopes :(

[Ramy Mahrous]

Check this http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/867b3a86-18ad-45f8-b051-4e7312233587/ or search on that http://www.google.com.eg/search?hl=en&q=Maximum+stored+procedure,+function,+trigger,+or+view+nesting+level+exceeded&btnG=Google+Search&meta=&aq=f&oq=