October 16, 2010 at 11:36 pm
what is hot fix service number ?what is build version?
.how do u know the all service packs,hotfixes, build versions which are installed in the server?
October 17, 2010 at 4:15 am
Run command select @@version
7.0.nnnn = SQL 7
8.0.nnnn = SQL2000
9.0.nnnn - SQL2005
10.0.nnnn = SQL2008
10.5.nnnn = SQL2008R2
nnnn denotes the SP\Hotfix level.
On this site do a search on 'build list'. Steve jones the editor helpfully maintains a list that will tell you which releases have been applied.
---------------------------------------------------------------------
November 2, 2010 at 6:44 pm
An alternative to what George posted is at: http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
This site includes not just major builds but build numbers including different patches and hotfixes.
November 3, 2010 at 9:51 am
The following site lists all versions of SQL with a link to what exactly is in each update/release.
http://sqlserverbuilds.blogspot.com/
Hope this helps.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply