Skip to content

Latest commit

 

History

History
72 lines (54 loc) · 2.99 KB

configurationsetting-method-generatedatabasecreationscript.md

File metadata and controls

72 lines (54 loc) · 2.99 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords apilocation apiname apitype
ConfigurationSetting method - GenerateDatabaseCreationScript
ConfigurationSetting method - GenerateDatabaseCreationScript
kfollis
kfollis
09/25/2024
reporting-services
wmi-provider-library-reference
conceptual
updatefrequency5
GenerateDatabaseCreationScript method
reportingservices.mof
GenerateDatabaseCreationScript (WMI MSReportServer_ConfigurationSetting Class)
MOFDef

ConfigurationSetting method - GenerateDatabaseCreationScript

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

Syntax

Public Sub GenerateDatabaseCreationScript(ByVal DatabaseName As String, _  
    ByVal Lcid As Int32, ByVal IsSharePointMode As Boolean, ByRef Script As String, _  
    ByRef HRESULT As Int32)  
public void GenerateDatabaseCreationScript(string DatabaseName, Int32 Lcid,   
    Boolean IsSharePointMode, out string Script, out Int32 HRESULT);

Parameters

Databasename
A string containing the name of the report server database to create.

Lcid
Value used for localization of role names.

IsSharePointMode
Indicates whether to create database in native mode or SharePoint mode.

Important

Beginning in [!INCLUDEssSQL11], IsSharePointMode=True is not supported because in SharePoint mode, [!INCLUDEssRSnoversion] is a SharePoint shared service and is not controlled by the WMI provider. You should always set this parameter to False.

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 nonzero value indicates that an error occurred.

Remarks

This method generates a SQL script that creates report server databases for the version of the report server currently connected to.

The value supplied in the DatabaseName parameter must conform to [!INCLUDEssNoVersion] database naming conventions.

The method doesn't check the existence of the database when generating the script.

This method doesn't check for the existence of the report server database when generating the script.

The generated script supports [!INCLUDEssVersion2000], [!INCLUDEssNoVersion] 2005, and [!INCLUDEsql2008-md].

Requirements

Namespace: [!INCLUDEssRSWMInmspcA]

Related content