sys.sp_syscollector_set_warehouse_database_name

general

#stored-procedure

Description

(with EXECUTE permission) fixed database role to The following example sets the name of the management data warehouse to System stored procedures (Transact-SQL)

Syntax

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

Examples

Example 1

RemoteMDW

Example 2

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