How to open an .MDF file? (Attach a Database in SQL Server)

This video shows how to attach a database in SQL Server 2008 R2. It covers a common Access Denied error and provides solutions. At the end, it briefly covers the Detach mechanism and the sp_helpfile procedure. More information can be found on this subject at: http://learningsqlserver.wordpress.com