在asp 中使用 sql_dmo 添加新數據庫 - 中國WEB開發者網絡 (http://www.webasp.net) -- 技術教程 (http://www.webasp.net/article/) --- 在asp 中使用 sql_dmo 添加新數據庫 (http://www.webasp.net/article/18/17285.htm)

-- 作者：未知 -- 發佈日期： 2005-03-31

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

webasp.net