Recently, I wanted to bring data into a SQL Server table, and I wanted to do so w/o SSIS. I know that I had done this before, but, of course, I had forgotten the details. I found the best answer…
Category: SQL 2000
Script version of SSMS “Sql Server Agent” Job Activity Monitor
Are you tired of “right-click” “refresh” on the job monitor? Want a single, simple script to tell you what step a job is at? Try this script:
Programmatically act on SQL Version
I often have scripts that run across multiple versions of SQL … more and more 2008’s and less and less 2000’s. In doing so, i need to take different actions based on that version. Here’s the simple technique that i…
Importing data from Excel
Importing data from excel is very easy and you have several options to get you started…
Why can’t I see more job history?
I’ve been a DBA for a long time… and it still takes me a minute of thinking before I remember how to see more job history. Furthermore, it takes a second try before I remember that the “Maximum job history…
Determine Backup schedules across multiple SQL Servers
Today some architecture changes were scheduled to occur in the evening. I wanted to adjust or disable backup jobs that could be affected. I have some 50 SQL servers. I needed to know when the backups were to start on…
Get Alerted when your 2000 SQL cluster fails over
Today, I want to show how to be alerted any time one of your clustered SQL 2000 server fails over. This will work whether some admin fails it over on purpose, or accidentally.