sp_add_targetsvrgrp_member (Transact-SQL)
Applies to:
SQL Server
Adds the specified target server to the specified target server group.
Transact-SQL syntax conventions
Syntax
sp_add_targetsvrgrp_member
[ @group_name = ] 'group_name'
, [ @server_name = ] N'server_name'
[ ; ]
Arguments
[ @group_name = ] 'group_name'
The name of the group. @group_name is sysname, with no default.
[ @server_name = ] N'server_name'
The name of the server that should be added to the specified group. @server_name is nvarchar(30), with no default.
Return code values
0
(success) or 1
(failure).
Result set
None.
Remarks
A target server can be a member of more than one target server group.
Permissions
This stored procedure is owned by the db_owner role. You can grant EXECUTE
permissions for any user, but these permissions may be overridden during a SQL Server upgrade.
Examples
The following example adds the group Servers Maintaining Customer Information
and adds the LONDON1
server to that group.
USE msdb;
GO
EXEC dbo.sp_add_targetsvrgrp_member
@group_name = N'Servers Maintaining Customer Information',
@server_name = N'LONDON1';
GO
Related content
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें