SQL Server 7.0 & Stored Procedures

SQL Server 7.0 & Stored Procedures

Post by Dan Gar » Wed, 10 Feb 1999 04:00:00



We are having problems with stored procedures that run fine on a 6.5 server
but do not run the same on the 7.0 server.  I build with sql script so the
procedures did not come over from the upgrade utility.


all values rather than only the info for #9.

Do I need to change the configureation on the SQL 7.0 server? And if so what
& how?

Dan

 
 
 

SQL Server 7.0 & Stored Procedures

Post by Richard Waymir » Wed, 10 Feb 1999 04:00:00


Can you post the section of the stored proc that's giving you difficulty?

--
Richard Waymire, MCT, MCSE+Internet, MCSD


>We are having problems with stored procedures that run fine on a 6.5 server
>but do not run the same on the 7.0 server.  I build with sql script so the
>procedures did not come over from the upgrade utility.


returns
>all values rather than only the info for #9.

>Do I need to change the configureation on the SQL 7.0 server? And if so
what
>& how?

>Dan