How to identify version of SQL Server2k:
Execute one of the following queries against an instance of the database engine by using isql, osql, or Query Analyzer. SELECT @@VERSION Find out your version of Database Components by means of the following table. SQL Server 2000 Version and Level @@VERSION Product Level SQL Server 2000 Original Release 8.00.194 RTM: Database Components SP1 8.00.384 SP1 Database Components SP2 8.00.534 SP2 Database Components SP3, SP3a or MSDE 2000 Release A. 8.00.760 SP3 Database Components SP4 8.00.2039 SP4 Note Your product version may be different than these values if you applied a hotfix after installing the product or after installing a previous service pack. For example, @@VERSION returns a value of 8.00.818 after you apply the security fix MS03-031 to SQL Server 2000 SP3a.
No comments:
Post a Comment