by Chris Woo » Fri, 13 Nov 1998 04:00:00
What updates the values returned by sp_server_info? We applied 6.50 SP4 some
get build 338. If I run sp_server_info I get build 281 for DBMS_VER and
6.50.193 for SYS_SPROC_VERSION.
Should I have, somehow, updated the sp_server_info data too?
Thanks
Chris WOOD
Alberta Department of Energy
CANADA
by Neil Pik » Sat, 14 Nov 1998 04:00:00
Neil Pike MVP/MCSE
Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)
by Chris Woo » Sat, 14 Nov 1998 04:00:00
The reason I was concerned is that I have a request to run a script,
instcat.sql, to make Visual Basic 6.0 work with our SQL Server 6.5 and the
script wants to update some of the values returned by sp_server_info. What
uses the values returned by sp_server_info and does it matter if they differ
from the actual, ie build?
Chris Wood
> Chris - these values are stored in the system tables. They aren't updated
by
>hotfixes. Nothing to worry about.
> Neil Pike MVP/MCSE
> Protech Computing Ltd
> (Please post ALL replies to the newsgroup only unless indicated otherwise)
by Neil Pik » Sat, 14 Nov 1998 04:00:00
Chris,Quote:> The reason I was concerned is that I have a request to run a script,
> instcat.sql, to make Visual Basic 6.0 work with our SQL Server 6.5 and the
> script wants to update some of the values returned by sp_server_info. What
> uses the values returned by sp_server_info and does it matter if they differ
> from the actual, ie build?
ODBC and higher-level protocols that use odbc check sp_server_info every time
they connect. They use this to decide what features are available - e.g.
server-side cursors and the like. It doesn't matter if INSTCAT.SQL updates
stuff.
Neil Pike MVP/MCSE
Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)
For some reason, the stored procedure sp_server_info has disappeared from my SQL Server 6.0 installation.
Without this, applications cannot connect through ODBC. Has anyone else experienced this? Is there any way to
restore a system stored procedure other than re-installing the server?
Thanks in advance!
2. microsoft index server example?
4. SQL Problem
5. odbc fails : sp_server_info
6. 15x Progress V8 Gui contracts in Sydney
7. difference between sp_server_info and @@Version after Installation of SQLSP3
8. Defending the network model (was: Re: Relational Databases an d Their Guts)
9. sp_server_info SPROC and "set textsize"