sp_remoteoption (Transact-SQL)
Applies to: SQL Server
Displays or changes options for a remote login defined on the local server running SQL Server.
Note
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.sp_remoteoption does not change any options and returns an error message. It is supported for backward compatibility only.
Transact-SQL syntax conventions
Syntax
sp_remoteoption [ [ @remoteserver = ] 'remoteserver' ]
[ , [ @loginame = ] 'loginame' ]
[ , [ @remotename = ] 'remotename' ]
[ , [ @optname = ] 'optname' ]
[ , [ @optvalue = ] 'optvalue' ]
Remarks
This stored procedure returns the following error message:
The trusted option in remote login mapping is no longer supported.
See Also
Váš názor
https://aka.ms/ContentUserFeedback.
Připravujeme: V průběhu roku 2024 budeme postupně vyřazovat problémy z GitHub coby mechanismus zpětné vazby pro obsah a nahrazovat ho novým systémem zpětné vazby. Další informace naleznete v tématu:Odeslat a zobrazit názory pro