Post reply

Database Size and Available Space

  • September 30, 2008 at 2:18 am

    #878702

    SET ROWCOUNT 10000

    DELETE FROM dbo.Table WHERE WhatEver

    Just be aware that if you have any triggers on the table you are deleting from, that SET ROWCOUNT will also affect the trigger.

Viewing post 16 (of 15 total)

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