sql server programming: Nested Stored procedure won't work on STRATUS server -- sql server programming

Nested Stored procedure won't work on STRATUS server

Peter
10/25/2006 9:44:02 PM

sql server programming: I have SQL 2000 SP3 installed on my machine used for devel and testing, I
have a client with a stratus box with sql 2000 sp3 installed, and same
database for testing. I have a stored procedure that is nested and calls
another. The stored procedure hangs when it calls the nested procedure, if I
take the contents of the nested procedure and put it back in the calling
procedure it works fine, if I try calling a different procedure it dies.

Is there some database setting perhaps which is different? What would the

Re: Nested Stored procedure won't work on STRATUS server

Tracy McKibben
10/26/2006 12:00:00 AM

[quoted text, click to view]

When it "hangs", look at sysprocesses - find the spid representing your
query, does it show as being blocked? Any wait type specified?

--
Tracy McKibben
MCDBA