主题：[求助]附加数据库

1. 首先设置一个外部数据源指向SQL2005任意一个数据库

2. 附加

Dim cmd1 As New SQLCommand
cmd1.C
cmd1.CommandText = "use master;EXEC sp_attach_db @dbname ='测试',@filename1 ='"& ProjectPath & "ADMIN\测试.mdf',@filename2 = '" & ProjectPath & "ADMIN\测试_log.ldf'"
cmd1.ExecuteNonQuery()

3.卸载

Dim cmd As New SQLCommand
cmd.C
cmd.CommandText = "use master;EXEC sp_detach_db '测试','true'"
cmd.ExecuteNonQuery()

Dim cmd1 As New SQLCommand
cmd1.ConnectionNa me = "测试"
cmd1.CommandText = "sel ect count(*) from sys.databases where name = '测试'"
Dim val  = cmd1.ExecuteScalar()
If val = 1 Then

msgbox("'测试'数据库存在")

else

'附加数据库

end if