Category Archives: SQL 2000

Import tab delimited data files directly into SQL Server via SSMS

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 … Continue reading

Posted in SQL 2000, SQL 2005, SQL 2008, SQL 2012, SQL Administration, SSIS | Tagged , , | Leave a comment

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:

Posted in SQL 2000, SQL 2005, SQL 2008, SQL Administration | Leave a comment

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 … Continue reading

Posted in SQL 2000, SQL 2005, SQL 2008, SQL Administration | Leave a comment

Importing data from Excel

Importing data from excel is very easy and you have several options to get you started…

Posted in SQL 2000, SQL 2005, SQL 2008 | Tagged , , , | Leave a comment

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 … Continue reading

Posted in SQL 2000, SQL 2005, SQL 2008, SQL Administration | Tagged | Leave a comment

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 … Continue reading

Posted in SQL 2000, SQL 2005, SQL 2008, SQL Administration | Tagged , , | Leave a comment

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. 

Posted in SQL 2000, SQL Clustering | Tagged , , | Leave a comment