Last post Jun 14, 2017 09:44 AM by EvenMa
Jun 13, 2017 05:31 PM|vinodkpasi|LINK
How many transaction log entry is done for "DROP TABLE" statement?
Jun 14, 2017 07:19 AM|PatriceSc|LINK
Each row deletion is logged. You have also the TRUNCATE TABLE statement which doesn't log row deletion (but you have also some restrictions). If you run into a particular issue or have a particular goal you may want to ask directly about it.
I always avoid to create/delete/truncate entire tables as part of my normal application level flow.
https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql#remarks for details
Edit2: I realized that for some reason I thought you were talking about DELETE. Anyway you could use the undocumented http://killspid.blogspot.fr/2006/07/using-fndblog.html function to
check yourself which entries are added to the log.
Jun 14, 2017 09:44 AM|EvenMa|LINK
According to your description, I’m unsure what did you mean.
I consider all the entry will be logged in the log file before drop table, when drop table, there has no operation to record entry into the log.
The entry log will be record on insert, update, delete and truncate.
You could refer to the following link to read more details about this issue.
If you have any other questions, please feel free to contact me any time.