Viewing 6 posts - 1 through 6 (of 6 total)
you need to setup a trace file. Then you can analyze information from past transactions.
August 9, 2012 at 1:56 am
Thanks for your reply Nils, I now realized that truncate is actually logged.
Quoting from: http://qa.sqlservercentral.com/articles/delete/61387/
TRUNCATE logs the deallocation of the data pages in which the data exists. TRUNCATE...
August 25, 2011 at 2:40 am
I think the question had multiple correct replies.
I answer:
Delete is logged, truncate is not logged.
Truncate resets the identity for a table, delete does not.
Which I believe is also...
August 25, 2011 at 2:18 am
Thanks David, but my question was different:
If I need to add mirroring on a production system which at the time consists
of a single server (db01), do I have to block...
April 12, 2011 at 6:06 am
Thanks for the article. A quick question:
on a production system, can I do the backup/restore steps without
blocking incoming connections? If this is true, then the transactions
issued after the backup,...
April 12, 2011 at 2:40 am
Viewing 6 posts - 1 through 6 (of 6 total)