Stored Procedures not working in MS-SQL 7

Abstract: How to get stored procedures which worked in MS-SQL 6.5 to work in MS-SQL 7
Question:

Why can't I use my MS-SQL 6.5 stored procedures in MS-SQL 7.0?

Answer:

Although the BDE can be used to connect to MS-SQL 7 tables, it only supports MS-SQL 6.5 features. Here's why.

In this case the new feature in MS-SQL 7 that is not supported is the ability to have two stored procedures with the same name and different parameters. You will notice Stored Procedures in MS-SQL 7 have a ;1 or ;2 after the name. If you have a procedure with a ;1 after it you should be able to remove the ;1 and use it without a problem. If it has a ;2 or higher after it you should rename the procedures which have the same name, and remove the ;# and then it should work okay.

Published on: 1/19/2000 12:00:00 AM

Server Response from: ETNASC03

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.