INF: INSCAT.sql Comment About Updating spt_server_info Can be Ignored (236563)


The information in this article applies to:

  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5
  • Microsoft SQL Server, Standard Edition 7.0
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: 
/*
<B>NOTE</B>: 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: 
/*
<B>NOTE</B>:  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')
*/
Modification Type:MajorLast Reviewed:11/14/2003
Keywords:kbinfo KB236563 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.