October 12, 1998

Log truncation

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

Rename a Login

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.