Susan Owen
Registered User.
- Local time
- Today, 02:56
- Joined
- Jul 8, 2002
- Messages
- 33
Probably hardly anybody else will encounter this, but I found it interesting anyway.
We have a working application back end MS-SQL 2000, front end MS-Access 2003. In one of our procedures, we run the sp_who system procedure to find out who is logged in, and write a table with the entire recordset received from the sp_who procedure.
We are testing upgrading from MS-SQL 2000 to MS-SQL 2005.
Well, in comparing the results of sp_who from MS-SQL 2000 and the results from MS-SQL 2005, I found that a new column was added at the end, "id_request". Our table was based on the exact number of columns of the sp_who result from MS-SQL 2000, so in order for our stored procedure to function correctly, I had to add a column to the table we were creating to accomodate the new column from the revised sp_who procedure.
I wonder if there have been any other such changes that might affect us... I don't think this change is documented anywhere (I just downloaded the latest Books Online from July 06 and haven't searched it yet, maybe there icould be something in there.)
We have a working application back end MS-SQL 2000, front end MS-Access 2003. In one of our procedures, we run the sp_who system procedure to find out who is logged in, and write a table with the entire recordset received from the sp_who procedure.
We are testing upgrading from MS-SQL 2000 to MS-SQL 2005.
Well, in comparing the results of sp_who from MS-SQL 2000 and the results from MS-SQL 2005, I found that a new column was added at the end, "id_request". Our table was based on the exact number of columns of the sp_who result from MS-SQL 2000, so in order for our stored procedure to function correctly, I had to add a column to the table we were creating to accomodate the new column from the revised sp_who procedure.
I wonder if there have been any other such changes that might affect us... I don't think this change is documented anywhere (I just downloaded the latest Books Online from July 06 and haven't searched it yet, maybe there icould be something in there.)
Last edited:
