sys.sp_rda_deauthorize_db (Transact-SQL)
Applies to:
SQL Server 2016 (13.x) and later versions
Removes the authenticated connection between a local Stretch-enabled database and the remote Azure database. Run sp_rda_deauthorize_db
when the remote database is unreachable or in an inconsistent state and you want to change query behavior for all Stretch-enabled tables in the database.
Important
Stretch Database is deprecated in SQL Server 2022 (16.x) and Azure SQL Database. This feature will be removed in a future version of the Database Engine. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Transact-SQL syntax conventions
Syntax
sp_rda_deauthorize_db
[ ; ]
Return code values
0
(success) or > 0
(failure).
Permissions
Requires db_owner permissions.
Remarks
After you run sp_rda_deauthorize_db
, all queries against Stretch-enabled databases and tables fail. That is, the query mode is set to DISABLED
. To exit this mode, do one of the following things:
Run sys.sp_rda_reauthorize_db (Transact-SQL) to reconnect to the remote Azure database. This operation automatically resets the query mode to
LOCAL_AND_REMOTE
, which is the default behavior for Stretch Database. That is, queries return results from both local and remote data.Run sys.sp_rda_set_query_mode (Transact-SQL) with the
LOCAL_ONLY
argument to let queries continue to run against local data only.
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