tag:blogger.com,1999:blog-8905997490259569264.post3716289662662389331..comments2024-03-06T07:38:54.040-05:00Comments on Gulfsoft Consulting Blog: How to find SQL Server Version?Frank Tatehttp://www.blogger.com/profile/16464603721492040411noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8905997490259569264.post-21672397253049142502009-06-22T10:23:24.455-04:002009-06-22T10:23:24.455-04:00Bazza,
Thank you for the additional information!...Bazza, <br /><br />Thank you for the additional information!Venkathttps://www.blogger.com/profile/15600493680764076181noreply@blogger.comtag:blogger.com,1999:blog-8905997490259569264.post-67047150016283341332009-06-22T08:39:47.474-04:002009-06-22T08:39:47.474-04:00In order to execute that SQL you must first connec...In order to execute that SQL you must first connect to the server in question.<br /><br />For those that like to steer well clear of executing any T-SQL - if you are using MS SQL Server Management Studio (came in with SQL2005), then the SQL version is given in brackets within the 'Object Explorer' view.<br />In the format: SERVERNAME\INSTANCE (SQL Server x.0.xxxx - USERNAME)<br />Where x is the version of SQL (8/9/10/etc), and xxxx is the revision number - see below).<br /><br />Failing that, right-click on the server (in 'Object Explorer') and select 'properties', and the version is given on the default ('General') tab.<br /><br />And, once you have the revision number, if you want more detail on exactly which revision of SQL you have:<br /><a href="http://support.microsoft.com/kb/321185" rel="nofollow">Microsoft: How to identify your SQL Server version and edition</a>Bazzahttps://www.blogger.com/profile/02608925614154030575noreply@blogger.com