question

hotdee avatar image
hotdee asked

How many stored procedure can I call from the same store procedure ? please one of the interviewer asked me

How many stored procedure can call from the store procedure ? please
sql-server-2008sql-server-2005sql-server-2000stored-procedures
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
If you mean in a nested approach, then the limit is 32. MSDN : http://msdn.microsoft.com/en-us/library/ms143432.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.