Could not find On Change - Log Only in Execution Mode

• Judy Why

  Hall of Fame

  Points: 3656

  More actions

  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!

• Judy Why

  Hall of Fame

  Points: 3656

  More actions

  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?