GenerateDatabaseCreationScript Method (WMI MSReportServer_ConfigurationSetting Class)

Generates a SQL Script that can be used to create a report server database.

Syntax

Public Sub GenerateDatabaseCreationScript(DatabaseName as String,_
    ByRef Script as String, ByRef HRESULT as Int32)
public void GenerateDatabaseCreationScript (string DatabaseName, 
    out string Script, out sint32 HRESULT);

Parameters

  • Databasename
    A string containing the name of the report server database to create.
  • Script
    [out] A string containing the generated SQL script.
  • HRESULT
    [out] Value indicating whether the call succeeded or failed.

Return Value

Returns an HRESULT indicating success or failure of the method call. A value of 0 indicates that the method call was successful. A non-zero value indicates that an error has occurred.

Remarks

The value supplied in the DatabaseName parameter must conform to SQL Server database naming conventions.

This method does not check for the existence of the report server database when generating the script.

The generated script supports SQL ServerĀ 2000 and SQL ServerĀ 2005.

Requirements

Namespace:root\Microsoft\SqlServer\ReportServer\v9\Admin

Platform: Windows Server 2003, Datacenter Edition; Windows Server 2003, Enterprise Edition; Windows Server 2003, Standard Edition; Windows Vista; Windows XP Professional with Service Pack 2 (SP2) or Service Pack 1 (SP1); or Windows 2000 (all versions)

See Also

Reference

MSReportServer_ConfigurationSetting Members
MSReportServer_ConfigurationSettingForSharePoint Members

Help and Information

Getting SQL Server 2005 Assistance