Setup email from MS SQL Server 2000 via a Notes server
First install Outlook 2000 on the server. Login as the user that you SQL service starts as (SQLService in our case). Run Outlook making sure you choose the Corporate or …
List your scheduled tasks next run time and average duration MSSQL
Here’s a handy little query I came up with to list your scheduled jobs, what time they’re going to run next and their average duration on your MSSQL box. I’ve …
CLear MSSQL DB log file without backing it up
This is one that has come in hand a few times, if you’ve accidentaly filled up you data drive on your SQL server and don’t have the space left to …