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
|
|
當前位置：開發者網絡 >> 技術教程 >> ASP教程 >> 數據庫相關 >> 內容
