>>If you have MSSQL.1-4 that you have 4 instances of SQL Server installed. Just try to connect to each one and see where the data is.
>
>Can you specify for dummies how to connect to each instance from SSMS?
>
>Looks like I'm connecting to the 4th instance instead of 1.
When you get Login dialog just open Server name combo. There you should have all instances of your server + all servers SSMS found.
Also if you open SQL Server Configuration Manager there you could see what services you have. On my office computer i have:
SQL Server (MSSQLSERVER)
SQL Server (SQLSERVEREXPRESS) (or something like that)
Right click on every instance and see all properties for it.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.