This method sets up a necessary tables and configuration information in a target server and database when partitioning a logical directory container across multiple SQL servers and databases.
IDL Definition
HRESULT CreatePartition(
[in] BSTR bstrServerName,
[in] BSTR bstrDatabaseName,
[in] BSTR bstrDBUserName,
[in] BSTR bstrDBPassword
);Parameters
bstrServerName
a name for the computer hosting the SQL server for this partition.
bstrDatabaseName
the name of the database to use for the partition.
bstrDBUserName
the username presented when authenticating to the SQL server.
bstrDBPassword
the password presented when authenticating to the SQL server.
Return Value
a standard HRESULT value
Example
Set ObjCreator = CreateObject("ObjCreator.ObjCreator.1")
Set DSConfig = ObjCreator.CreateObjAuth("MemAdmin.DSConfig.1")
DBUser="sa"
DBPass="password-here"
Database="some-database"
Server="someserver"
call DSConfig.CreatePartition(Server,Database,DBUser,DBPass)
If Err.Number <> 0 Then
WScript.Echo "Error creating partition: " & Err.Description
End If