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.