Post reply

Could not find On Change - Log Only in Execution Mode

  • September 20, 2010 at 8:40 am

    #224189

    Hi,

    I just installed SQL Server 2008 in Windows XP.

    Here is result from select @@version

    Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 2).

    When I tried to create new Policy, from Execution mode dropdownlist, I only found two options:"on Demand" and "on Schedule", no other two.

    is this SQL Server 2008 version not supporting this? Or what setting should I configure to enable these two options?

    Thank you for your help in advance!

  • September 21, 2010 at 9:18 am

    #1224940

    I may need to clarify my question.

    I open SSMS in SQL Server 2008, try to create a new policy. From "Evaluation Mode" interface, It is only listing two mode "On demand" and "On schedule". I read some articles say there are four Evaluation Mode, except these two, I should see "On Change - Log Only" and "On Change - Prevent

    ".

    can someone help me to figure it out?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply