Identify the SQL Server version and instance
1. Log in to the Windows Server system hosting your SQL Server database.
2. Open a command prompt window.
3. Execute the following command:
4. SQLCMD -S servername\instancename
5. where servername is your server name and instancename is the SQL instance name.
6. Enter select @@version and press <Enter>.
7. At the 2 > prompt, type go and press <Enter>.
8. The SQL version running on the server displays in the dialog box.
9. Repeat step 3 through step 5 for each additional instance.