Microsoft KB Archive/236563

= INF: INSCAT.sql Comment About Updating spt_server_info Can be Ignored =

Article ID: 236563

Article Last Modified on 11/30/2007

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q236563



SUMMARY
The file INSCAT.sql, which comes with SQL Server 6.x and 7.0, has a comment in the beginning that states one must change the last row inserted into spt_server_info to be the version number of the file.

This comment is for internal use only and not for users who apply INSCAT.sql to their SQL Server.



MORE INFORMATION
INSCAT.sql for SQL Server 6.5 states the following: /* NOTE: You MUST change the last row inserted into spt_server_info to be version number of this file. the convention is j.nn.bbb,

where jj is the major version number ('6' now), nn is the minor version

number ('50' now), and bbb is the build number. INSCAT.sql for SQL Server 7.0 states the following: /* NOTE: you MUST change the last row inserted into spt_server_info to be version number of this file. the convention is j.nn.bbb,

where j is the major version number ('7' now), nn is the minor version number ('00' now), and bbb is the build number. insert into spt_server_info values (500, 'SYS_SPROC_VERSION', '7.00.bbb')

Keywords: kbinfo KB236563

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.