sp_syscollector_set_warehouse_database_name (Transact-SQL)
Applies to:
SQL Server
Specifies the database name defined in the connection string used to connect to the management data warehouse.
Transact-SQL syntax conventions
Syntax
sp_syscollector_set_warehouse_database_name [ [ @database_name = ] N'database_name' ]
[ ; ]
Arguments
[ @database_name = ] N'database_name'
The name of the management data warehouse. @database_name is sysname, with a default of an empty string.
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
Related content
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru