在asp 中使用 sql_dmo 添加新数据库-ASP教程,数据库相关
来源:作者: 发布时间:2007-12-26 02:03:16

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
|
还没有关于此文章的相关评论!