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

• Microsoft SQL Server versions 6.0, 6.5
• Microsoft SQL Server, Standard Edition, version 7.0

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.
*/  

/*
<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')
*/ 

Additional query words:

Keywords          : kbSQLServ600 kbSQLServ650 kbSQLServ700 
Version           : winnt:6.0,6.5,7.0
Platform          : winnt 
Issue type        : kbinfo 

Last Reviewed: August 2, 1999