Is there a way to stop logging DML? I have a large delete and I dont want to log the operation, is it possible?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|||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?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment