Problems with SP and NULL values.

Hi friends.
I have two servers, one with SQL 7.0 SP4 (Production server) and the
development server with SQL 2000 SP3.
One developer tells me that in the development server the store procedures
he creates permits the NULL output. On the production server, he says that
the SP migrated, does not permit a NULL output.
Is this true? how can i check this?
Thanks all.Output *parameters* may be NULL. *RETURN values* must be a non-NULL integer,
although this is handled as a warning rather than an error in 2000. May have
been different in 7.0, I don't recall. Don't try to return a NULL RETURN
value.
You use SQL2000 as a dev box for a 7.0 production server?! Good luck! ;-)
David Portas
SQL Server MVP
--|||Thanks David, the developer has corrected the scripts and now all is working
fine.
I dont unterstand why the developers have migrated to SQL 2000 without
permission, i am new to the company, so my next task will be migrate the SQl
7.
Thanks again.