开发者

T-SQL Options ( Microsoft SQL Server) [closed]

开发者 https://www.devze.com 2023-03-17 07:51 出处：网络

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references,or expertise, but this question will likely solicit debate, a

相关专题：sql sql-server tsql

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. 开发者_如何学C Closed 11 years ago.

Why can't I use the RECOMPILE option along with FOR REPLICATION when creating stored procedures?

MSDN explicitly states

FOR REPLICATION

Specifies that stored procedures created for replication cannot be executed on the Subscriber. A stored procedure created with the FOR REPLICATION option is used as a stored procedure filter and only executed during replication. This option cannot be used with the WITH RECOMPILE option.

Why they choose not to allow this is beyond me.