sp_syscollector_set_warehouse_database_name (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Specifies the database name defined in the connection string used to connect to the management data warehouse.

Topic link icon Transact-SQL Syntax Conventions

Syntax


sp_syscollector_set_warehouse_database_name [ @database_name = ] 'database_name'  

Arguments

[ @database_name = ] 'database_name'
Is the name of the management data warehouse. database_name is sysname with a default value of NULL.

Return Code Values

0 (success) or 1 (failure)

Remarks

You must disable the data collector before changing the data collector-wide configuration. This procedure fails if the data collector is enabled.

To view the current database name, query the syscollector_config_store system view.

Permissions

Requires membership in the dc_admin (with EXECUTE permission) fixed database role to execute this procedure.

Examples

The following example sets the name of the management data warehouse to RemoteMDW.

USE msdb;  
GO  
EXEC sp_syscollector_set_warehouse_database_name N'RemoteMDW';  
GO  

See Also

System Stored Procedures (Transact-SQL)