Export (0) Print
Expand All

sp_syscollector_set_warehouse_database_name (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

sp_syscollector_set_warehouse_database_name [ @database_name = ] 'database_name'

[ @database_name = ] 'database_name'

Is the name of the management data warehouse. database_name is sysname with a default value of NULL.

0 (success) or 1 (failure)

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.

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

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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft