October 12, 1998

<img width="300" height="200" src="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg" class="elementor-animation-grow attachment-full size-full wp-image-23374" alt="" loading="lazy" />

Rename a Login

October 12, 1998

Question: Is it possible to rename a login? Answer: Sorry, no. You must drop the login and then create a new one with the corrected name.

<img width="300" height="200" src="https://www.devx.com/wp-content/uploads/2022/02/thumbnail.jpg" class="elementor-animation-grow attachment-full size-full wp-image-23374" alt="" loading="lazy" />

Log truncation

October 12, 1998

Question: My database and log keep filling up and I can’t truncate the log. Any suggestions? Answer: There are two methods to empty the transaction log. One can regularly dump