Let me explain my query in detail: 1. I have installed MS SQL Server 2008 R2 on my machine version: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)   Jun 17 2011 00:54:03   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64>  (Build 7601: Service Pack 1)  2.On top of it I have added feature to add SQL Server express 2008 version: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Express Edition with Advanced Services (64-bit)  on Windows NT 6.2 <X64> (Build 9200: )  3. Upon installing SQL express, I was able to create database (TestExpDb) through SQL server management studio.
4. After this, I detached database through SSMS. 5. Then tried attaching same through SSMS and I was able to do so. 6. Also when tried ...

Go to the complete details ...