Identify a SQL Server Express Instance

In this post we will see how to Identify a SQL Server Express Instance using a SQL query.

Open SQL Server Management Studio. Open the query analyzer and write the following query.

SELECT@@VersionAS'SQL Server Version'

When we run the preceding SQL command we get the SQL Server Version.



By running this query we get the Instance of the SQL Server installed on the system. Stay tuned for more posts.