Attach database file mdf in SQL 2000 without i have ldf log file

EXEC sp_detach_db @dbname = 'pubs'
EXEC sp_attach_single_file_db @dbname = 'pubs',
   @physname = 'c:"Program Files"

Microsoft SQL Server"MSSQL"Data"pubs.mdf'

 

posted @ 2009-05-14 10:46  See Me Fly  阅读(270)  评论(0)  编辑  收藏  举报