Use jscript Create a SQL Server database

Create a SQL Server database.
Copy codeThe Code is as follows:
DB_SIZE_IN_MEGABYTES = 5
StrDBServerName = "."

Set objSQLServer = CreateObject ("SQLDMO. SQLServer ")
ObjSQLServer. LoginSecure = True
ObjSQLServer. Connect strDBServerName

Set objDB = CreateObject ("SQLDMO. Database ")
Set objFG = CreateObject ("SQLDMO. Filegroup ")
Set objDBFile = CreateObject ("SQLDMO. DBFile ")
Set objLogFile = CreateObject ("SQLDMO. LogFile ")

ObjDB. Name = "ScriptingGuysTestDB"
ObjDBFile. Name = "ScriptingGuysTestDB_Data"
ObjDBFile. PhysicalName = "C: \ Program Files \ Microsoft SQL Server \ MSSQL \ data \ ScriptingGuysTestDB_Data.MDF"
ObjDBFile. Size = DB_SIZE_IN_MEGABYTES

ObjDB. FileGroups ("PRIMARY"). DBFiles. Add (objDBFile)

ObjSQLServer. Databases. Add (objDB)