Skip to content
SQLInsight

SQLInsight

We Do SQL Right!

  • What’s New
  • Power BI Gallery
  • PowerPoint Downloads
  • About Us
  • Contact Us
  • Home
  • SQL 2000

Category: SQL 2000

Import tab delimited data files directly into SQL Server via SSMS

June 1, 2016 Steve Schneider

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…

Read more

SQL 2000, SQL 2005, SQL 2008, SQL 2012, SQL Administration, SSISData Import, SSIS, tab delimitedLeave a Comment on Import tab delimited data files directly into SQL Server via SSMS

Script version of SSMS “Sql Server Agent” Job Activity Monitor

June 25, 2012 Steve Schneider

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:

SQL 2000, SQL 2005, SQL 2008, SQL AdministrationLeave a Comment on Script version of SSMS “Sql Server Agent” Job Activity Monitor

Programmatically act on SQL Version

February 28, 2012 Steve Schneider

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…

Read more

SQL 2000, SQL 2005, SQL 2008, SQL AdministrationLeave a Comment on Programmatically act on SQL Version

Importing data from Excel

July 25, 2011 Steve Schneider

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

SQL 2000, SQL 2005, SQL 2008Data Import, Excel, Import, SQLLeave a Comment on Importing data from Excel

Why can’t I see more job history?

July 19, 2011 Steve Schneider

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…

Read more

SQL 2000, SQL 2005, SQL 2008, SQL AdministrationSQL Job historyLeave a Comment on Why can’t I see more job history?

Determine Backup schedules across multiple SQL Servers

July 12, 2011 Steve Schneider

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…

Read more

SQL 2000, SQL 2005, SQL 2008, SQL AdministrationBackups, SQL 2008, SQL Server 2005Leave a Comment on Determine Backup schedules across multiple SQL Servers

Get Alerted when your 2000 SQL cluster fails over

February 3, 2010 Steve Schneider

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. 

SQL 2000, SQL ClusteringSql 2000, Sql Alerts, Sql ClusterLeave a Comment on Get Alerted when your 2000 SQL cluster fails over
Copyright SQL Insight 2017 © All rights reserved.
Business Era by mProThemes