exec sp_attach_db @dbname=N'AdventureWorks',
@filename1=N'D:/program files/Microsoft SQL Server/AdventureWorks_Data.mdf',
@filename2=N'D:/program files/Microsoft SQL Server/AdventureWorks_log.ldf'
注意大小写,这是最正确的添加方法了,把 路径换成你安装的位置就可以了
exec sp_attach_db @dbname=N'AdventureWorks',
@filename1=N'D:/program files/Microsoft SQL Server/AdventureWorks_Data.mdf',
@filename2=N'D:/program files/Microsoft SQL Server/AdventureWorks_log.ldf'
注意大小写,这是最正确的添加方法了,把 路径换成你安装的位置就可以了