Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    16

    Unanswered: DML without logging

    Is there a way to stop logging DML? I have a large delete and I dont want to log the operation, is it possible?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Truly non-logged operations are not possible in MS-SQL.

    The closest you could probably get would be to copy the data to another data source (most probably a file), delete the data there, truncate your original table, then reload the edited data source back into your table.

    -PatP

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    No...

    But you can bcp the data you want to keep, TRUNCATE the TABLE and then bcp the data back in...use native mode (-n)

    EDIT: DAMN, sniped again

    And Non logged is a misnomer...even TRUNCAT is logged...but at the page level (I think)

    Pat?
    Last edited by Brett Kaiser; 06-11-04 at 16:40.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •