人生是一场不能存盘的RPG,我只能尽量多搞几个Screenshot

October 23, 2006

如何识别SQL server以及service pack的版本

Filed under: SQL&DB Accessing

方法1.执行 select @@version
SQL Server 2005 RTM版本为9.00.1399.06
SQL Server 2005 SP1版本为9.00.2047.00 (我目前的版本)
SQL Server 2005积累补丁版本为9.00.2153.00

方法2.执行
SELECT SERVERPROPERTY(’productversion’), SERVERPROPERTY (’productlevel’), SERVERPROPERTY (’edition’)
http://support.microsoft.com/kb/321185/zh-cn

Comments »

The URI to TrackBack this entry is: http://recordsome.blogsome.com/2006/10/23/p177/trackback/

No comments yet.

RSS feed for comments on this post.

Leave a comment

Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>



Anti-spam measure: please retype the above text into the box provided.






















Get free blog up and running in minutes with Blogsome
Theme designed by Hadley Wickham