Adding a Microsoft SQL Server 2005 Database

Note: For successful Microsoft SQL Server 2005 database creation, the server administrator must select the option enable database management during site creation.

Syntax:

• When the arguments are passed in the form of an XML file:

  addobj.exe -t database -f <location_of_XML_file> -u <parent_username> -p <parent_password>

• When the arguments are passed in the form of a string containing XML data:

  addobj.exe -t database -s <XML_data_as_a_string> -u <parent_username> -p <parent_password>

Arguments:

The parameters to be passed in the XML file for adding a user are given below.

<?xml version="1.0" encoding="utf-8" ?>

<mssqldb>

<property name="databasename">Siteadmindatabase</property>
<!-- The name of the database to add-->

<property name="sitename">site.com</property>
<!-- Site's short name-->

</mssqldb>