Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pattikay
Starting Member
36 Posts |
 Posted - 2001-06-22 : 03:47:57
|
| I created a stored procedure on sql 7.0.It is called by an application created using Visual Basic.I installed a new server on the network that runs sql 2000.I copied the stored procedure from sql 7.0 to sql 2000 without any problems.When the application calls the procedure on the database running sql 2000,the application does not return any matches.When i got the string that Visual Basic is passing to sql 7.0 and executed the procedure on Query analyzer,I got matches.Upon further investigation, it seems the application is recieving a closed record set,in other words, no matches were being passed to it by sql 2000.My question therefore is,are there any keywords that are used in sql 7.0 that can make sql 2000 close a recordset?(note:there are no 'print' statements in the procedure) |
|
|
|
|
|
Stored Procedure does not run on sql2000.