Here`s a fun one: Nested Stored Procedures

I have a few stored procedures of the format:

create procedure foo

yadda yadda

exec foo;5

go

create procedure foo;5

yadda yadda

go

SQL enterprise 7.0 doesn`t appear to understand sub procedures (BUG?). When I try to save or check syntax on a stored procedure like the one above I get ODBC errors. The workaround I have is that everytime I modify the stored procedure I create the separate groups/procedures at an SQL query window. Needless to say this is a messy solution, anyone know what the deal is with this? This worked flawlessly with SQL 6.5.


Anthony Kenitzki