Want to know what version of SQL server your have running? All we need to do is execute one SQL command and away we go 🙂
- Go to your SQL server
- Open up the Microsoft SQL Server Management Studio
- Start->All programs->Microsoft SQL Server 2008 R2->SQL Server Management Studio
- Login with your user
- Click the New Query button
- Execute the following query
- SELECT SERVERPROPERTY('edition')