在asp 中使用 sql_dmo 添加新数据库

set oSQLServer =server.createobject("SQLDMO.SQLServer")
oSQLServer.Connect  "数据库IP,端口","用户名","密码"                          '''' 连接数据库
set oSQLServer =server.createobject("SQLDMO.Database")
set oDBFileData =server.createobject("SQLDMO.DBFile")
set oLogFile =server.createobject("SQLDMO.LogFile")
oDatabase.Name = "test"
oDBFileData.Name = "test1"
oDBFileData.PhysicalName = "c:\program files\microsoft sql server\mssql\data\test.mdf"
oDBFileData.PrimaryFile = True
oDBFileData.FileGrowthType = SQLDMOGrowth_MB
oDBFileData.FileGrowth = 1

oDatabase.FileGroups("PRIMARY").DBFiles.Add oDBFileData

oLogFile.Name = "test1"
oLogFile.PhysicalName = "c:\program files\microsoft sql server\mssql\data\test.ldf"
oDatabase.TransactionLog.LogFiles.Add oLogFile

oSQLServer.Databases.Add oDatabase

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18