how can i find out the version of SQL express installed on my machine?

Experts

is there a way to f开发者_StackOverflow社区ind out the version of SQL express installed on my machine?

---

Connect to it using SQL Server Management Studio (or some other sql client) and run:

SELECT @@VERSION

This will give you detailed information about the version you are connected to. An example from my installation:

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64)
Jul 9 2008 14:17:44
Copyright (c) 1988-2008 Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1)