>>>>I thought that at some point in the past I installed SQL Server 2016. If I go to Programs I see SQL Server 2016 with SSMS and other items. But now I am wondering if I simply installed the SSMS 2016 and not the database. Because when I start SSMS 2016 the DB version still shows the old version (10.00.5500).
>>>>How do I find out if SQL Server 2016 is actually installed on my PC?
>>>
>>>I always prefer to do things with script.
>>>
>>>However, in that page, it sums it all pretty much:
>>>
>>>
https://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-server-version-you-are-running>>
>>Thank you. I found that I don't have SQL Server 2016 on my computer but only SSMS 2016.
>
>Hi, Dmitry, if I can make a suggestion - I use VMWare and I have separate VM instances for 3 different versions of SQL Server (and along with that, 3 different versions of Visual Studio and SSMS). I do most of my work in SQL 2016 these days, but I do have to support some things in SQL 2012 and SQL 2008R2. Yes, it requires a machine with enough juice to effectively support virtual machines, but it makes life much easier.
Thank you, Kevin. Do you have Windows 7 or Windows 10 on your PC? And how much RAM?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham