SQL ERRORLOG is not optimally configured fresh out of the box. Here are a few ideas on how to make it better. There are few issues of how SQL Server sets up ERRORLOGs by default: 1. Only 7 log files are kept by default. 2. Files grow indefinitely. I (usually) do a few things to … Read more
TSQL DROPs for temp tables, procs, functions, SQLAgent jobs, synonyms This is probably the most simple TSQL I will ever post. However, it becomes useful more often than it would seem. Many times I will write a script/proc or get someone else’s code which doesn’t do any checking or clean up. Temp table drop TSQL … Read more
SQLAgent job owner change TSQL TSQL to change SQLAgent job owner Today I discovered many SQLAgent jobs had non-sa ownership of the job. It was replication jobs created by me. Here is a TSQL script to change job ownership from whatever user to ‘sa’. Or to whatever user you want. Just change two parameters: @NewOwner and … Read more