Identify a SQL Server Express Instance

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

  1. 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.