January 17, 2010 by pinaldave
It is quite common to get the SQL Server version details from following query.
SELECT @@VERSION VersionInfo
GO
Recently I have been using following SP to get version details as it also provides me few more information about the server where the SQL Server is installed.
EXEC xp_msver
GO
Watch a 60 second video on this subject
I like to use the second one but again that is my preference.
Reference: Pinal Dave (http://blog.SQLAuthority.com)
Pinal Dave is a Pluralsight Developer Evangelist. He has authored 9 SQL Server database books and have written over 2500 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 9+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ. Prior to joining Microsoft he was awarded the Microsoft MVP award for three continuous years for his contribution in the community. Here is the list of the Pinal Dave's books.
Follow @pinaldave
Send +Pinal Dave
an email at pinal@sqlauthority.com
Hey Pinal,
This may not be the right thread for such question/help, but I could not find any other.
Actually I am trying to install SQL Server 2005 Enterprise Edition (x32) on Windows 7 (64 bit), but getting lot of errors like Asp.Net is not registered with IIS etc.
Please guide me as how can I install it successfully. Do I need to do some settings before installing SQL Server – 32 bit on Windows 7 – 64 bit ?
Please help …!
Thanks,
Munish Bansal
Hi Pinal
how to see the latest version info in sql
for example
if i am using 2005 sql server,
i want the information about latest product (2012 RCO) like that
Thanks in advance
Gopi
[...] Get Server Version and Additional Info [...]
xp_msver does not work on SQL 2000, the very reason I want to use it,