补充: 我链接到数据库引擎后提示是这样的:XKHX\SQL2005 (SQL Server 9.0.3042 - sa)不晓得是不是打过补丁的.
select @@version查看版本信息
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2) 这个应该是最新的。
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')其中 SQL Server 2005 Service Pack 1 2005.90.2047 SQL Server 2005 Service Pack 2 2005.90.3042
建议打SP2的时候慎重, SP2不稳定,SELECT @@versionHow to obtain the latest service pack for SQL Server 2005 http://support.microsoft.com/kb/913089/ 升级之前请先看看这份文章. SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained http://blog.csdn.net/hery2002/archive/2008/04/02/2243564.aspx
SQL Server 2005 Service Pack 1 2005.90.2047
SQL Server 2005 Service Pack 2 2005.90.3042
SP2不稳定,SELECT @@versionHow to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089/
升级之前请先看看这份文章.
SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained
http://blog.csdn.net/hery2002/archive/2008/04/02/2243564.aspx