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
I like to use the second one but again that is my preference.
Reference: Pinal Dave (http://blog.SQLAuthority.com)
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2000 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of three SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.
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