T-SQL Options ( Microsoft SQL Server) [closed]
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.
精彩评论