sp_rda_reauthorize_db [英] sp_rda_reauthorize_db

问题描述

显然，SQL 2016 RC0中的名称和参数列表已更改，我无法在任何地方找到更新的文档。那么有人可以向我提供更新的参数列表。

Appararently the names and list of parameters have changed in SQL 2016 RC0 and I can't find the updated documenation anywhere. So can somebody please provide me with the updated list of parameters.

在CPT 3.3中，这有效：

In CPT 3.3 this worked:

EXEC

sp_rda_reauthorize_db @ Azure_credentialName = xxxx ;

显然，凭证的新参数名是@Credentialname，但现在该过程需要一个新参数@with_copy的值。我将在2天内提出这个问题，所以我很匆忙..

Apparently the new paramername for the credential is @Credentialname but the procedure now needs a value for a new parameter @with_copy. I am going to present this in 2 days so I am in kind of a hurry..

TIA

go

bobhen

推荐答案

SP如何处理参数存在缺陷。它具有强类型，这与SP不常见，因此为@with_Copy提供1或0以暗示位值将导致错误输出。请尝试以下操作：

There's a defect in how the parameters are handled by the SP. It has strong typing which isn't common with SPs so supplying 1 or 0 for @with_Copy to imply bit value will error out. Try the following:

Declare @credName nvarchar(128), @copy bit
SET @credName = N'MyDBCredential'; 
SET @copy = 0;
EXEC sp_rda_reauthorize_db @credential=@credName, @with_copy=@copy

您还需要在重新验证成功完成后设置查询模式： 

You will also need to set the query mode after re-auth completes successfully: 

Sp_rda_set_query_mode @mode= local_and_remote | local_only | disabled

这些选项非常明显，但我认为这些选项都不在BOL中。 

the options are pretty self-explanatory but I don't think these are in BOL either. 

请提交当你有机会时，https：//connect.microsoft.com/SQLServer/feedback/中的doc bug。 

Please file a doc bug in https://connect.microsoft.com/SQLServer/feedback/ when you get a chance. 

谢谢。

这篇关于sp_rda_reauthorize_db的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！