Use This SP to Generate a SQL Server Job Report Have you ever wanted to create a report listing all of the SQL Server jobs on your SQL Server 7.0 or 2000 servers? This is easy if you use the stored procedure I have created just for this purpose
All About Passwords Neil Boyle explains the mechanisms SQL Server uses to secure itself from unauthorized access, and discusses best practice for selecting and administering passwords
An Introduction to Triggers -- Part I A trigger is a database object that is attached to a table. In many aspects it is similar to a stored procedure. As a matter of fact, triggers are often referred to as a "special kind of stored procedure." The main difference between a trigger and a stor..
An Introduction to Triggers -- Part II A few months ago I wrote an article for SQLTeam called An Introduction to Triggers -- Part I. The article covered trigger fundamentals--the most important being the way the inserted and deleted virtual tables work. I also showed an example of how to use ..
Creating DTS Packages With SQL Server 2000 Back in the days when Microsoft SQL Server 6.5 was still hot property, the bulk copy program was the only way to backup or export databases from SQL Server to other data sources, such as other database servers or text files. DBA's INSERT INTO `sites` VALUES(Database Administrator..
Are SQL Server Temp Tables Really Necessary? Learn the the pros and cons of using SQL Server temp tables. Also find out how to optimize temp tables, assuming you can't find a way to avoid using them
Auditing Your SQL Server Environment Part I This article is the first of a series that I plan on writing and placing on my website to help other DBAs in auditing a new SQL Server environment. This article deals with determing which SQL Server logins have weak passwords, with the definition of weak
Comparing Tables We're in the process of rolling out a new version of a SQL Server-based software package at work. I already have numerous scripts that load tables and I was trying to find out which ones would break. I needed an easy way to compare tables
Beware of Mixing Collation with SQL Server 2000 - Part 1 Gregory A Larsen explains a few things that need to be understood about mixing collations, now that it is possible to have multiple collating sequences on a single database server