06 (Intel X86)Ĭopyright (c) 1988-2005 Microsoft Corporationĥ.1 (Build 2600: Service Pack 2) SQL Server 2008 SELECT this is T-SQL code or a stored procedure with this command is run it will give you information such as theīuild number and Windows Server operating system: SQL Server 2000 Server 6.5 and SQL Server 7.0 in Enterprise Manager. As you can see with the SQL Server 2000 screenshot itĪlso shows you the service pack that is installed, this is similar for SQL The "Product version" or "Version" gives you a number of the In the general section you will see information such as on the following The first is by using the functionality in SQL Server Management StudioĪnd right clicking on the instance name and selecting Properties. Method 1 - Find Microsoft SQL Server Version with SSMS
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |