exec sp_attach_db @dbname=N‘LabelLive‘,
@filename1 = N‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\LabelLive.mdf‘,
@filename2 = N‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\LabelLive_log.ldf‘
原文:http://www.cnblogs.com/accumulater/p/6345065.html