I'm not being snarky that comment is a subtle hint.

The old

EXEC sp_attach_db @dbname = N'AdventureWorks2012', @filename1 =

N'C:\Somepath\AdventureWorks2012_Data.mdf', @filename2 =

N'C:\Somepath\AdventureWorks2012_log.ldf';

The new

CREATE DATABASE database_name

ON PRIMARY (name=mydb_data, filename='d:\somepath\mydbdata.mdf')

LOG ON (name=mydb_log, filename='e:\somepath\mydblog.ldf')

FOR ATTACH