the above answer is partially correct, sp's can call another sp but

Can a stored procedure call another stored procedure. If yes
what level and can it be controlled?

Question Posted / kalyan

Answer Posted / kalyan

the above answer is partially correct, sp's can call
another sp but the levels is only upto 32.

Is This Answer Correct ?

20 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is snapshot report?

164

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

999

How would you use user_constraints table in DB?

998

What is the openxml statement in sql server?

1057

What is scrollable cursor?

1025

Why use view instead of a table?

935

What is an identity?

999

What is mscorsvw.exe - process - microsoft .net framework ngen?

943

what is the difference between a primary key and a unique key? : Sql server database administration

988

How to test values returned by a subquery with the in operator?

1183

What are the system database in sql server 2008?

1024

Why truncate is ddl?

1077

What is Federation Root Database?

104

What is the difference between dbcc indexdefrag and dbcc reindex?

981

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1317