EXEC sp_detach_db 'pubs', 'true' --分离数据库
EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'd:/Program Files/Microsoft SQL Server/MSSQL/Data/pubs.mdf',
@filename2 = N'd:/Program Files/Microsoft SQL Server/MSSQL/Data/pubs_log.ldf'
--附加数据库
EXEC sp_detach_db 'pubs', 'true' --分离数据库
EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'd:/Program Files/Microsoft SQL Server/MSSQL/Data/pubs.mdf',
@filename2 = N'd:/Program Files/Microsoft SQL Server/MSSQL/Data/pubs_log.ldf'
--附加数据库