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 here:
The solution requires putting a “Schema.ini” file in the same directory as the file you are attempting to upload, and the file HAS TO BE NAMED “schema.ini” (case insensitive). The contents of the simple text file should be as follows:
Continue reading “Import tab delimited data files directly into SQL Server via SSMS”
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: Continue reading “Script version of SSMS “Sql Server Agent” Job Activity Monitor”
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 have developed … it currently depends on Microsoft continueing to use periods in their version naming scheme… i don’t think that that will change soon!
Importing data from excel is very easy and you have several options to get you started… Continue reading “Importing data from Excel”
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 each server. I found a nice script at http://www.mssqltips.com/tip.asp?tip=1622to do that for a single server. Continue reading “Determine Backup schedules across multiple SQL Servers”
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. Continue reading “Get Alerted when your 2000 SQL cluster fails over”