Limiting the number of rows in a snapshot

  • SQL 2K

    How do you change the default of 100K

    Thanks


    John Zacharkan

  • You need to create a custom snapshot agent profile. Right click on the snapshot agent, select profile and when create your own.

     

    Hope this helps

    M

    [font="Verdana"]Markus Bohse[/font]

  • That's it thanks!!


    John Zacharkan

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

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