Post reply

How to leave a long running process?

  • November 11, 2011 at 9:42 am

    #390841

    Hi All,

    I just wanted to know if there was a way to leave a transaction\process that works its way through 4 million records removing duplicates overnight in a MSSQL Studio window without the risk of loosing all that has been processed?

    Thanks

  • November 11, 2011 at 9:44 am

    #1406424

    Assuming it's not all in the same transaction there can't really be huge problems with that unless you have competing processes for the same data during the night.

  • November 11, 2011 at 9:47 am

    #1406429

    You can create a job and let it run. That way you dont have to run it from your SSMS on your laptop.

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

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