Three vulnerabilities, the most serious of which could enable an attacker to gain control over an affected server.

by Brad M. McGehee – Learn about the “big picture” of SQL Server-based software development from an industry veteran.

Auto-Inserts creates insert scripts from any Microsoft® SQL Server© 7 or 2000 database that can be archived, emailed, checked into source control, run against another database etc. Auto-Inserts handles Identity fields and can auto-sequence the scripting order and even suppress constraints and trigg

By Rich Rollman – If you’re writing an application that uses XML as a data-interchange format, you need a way to extract the data from the XML document and store that data in your database. T-SQL’s OpenXML keyword is a convenient way to insert, delete, and update data in SQL Server 2000. OpenXML cre

In this article, Alexander Chigrik defines some general SQL Server replication topics,including replication topologies, replication types, and replication agents; and alsodiscusses Transactional replication. He then illustrates these concepts with a step-by-stepguide to setting up a Transactional re

This article is based on INF: Moving SQL Server Databases to a New Location with Detach/Attach (Q224071). During the process of testing this process on a test server and moving the model and msdb databases a "funny" thing happened, the model database "disappeared". Here’s what happened and why and h

Microsoft distributes SQL Server 2000 security fixes as one downloadable file. Because the security fixes are cumulative, each new release contains all of the security fixes that were included with the previous SQL Server 2000 security fix release. You do not have to install a previous patch before

By Dennis Fisher – Microsoft Corp. on Wednesday unleashed a flurry of security bulletins warning of problems in several of its products, including SQL Server 2000, Exchange 5.5 and Metadirectory Services 2.2.

By Brian Moran – You wouldn’t accept faulty engineering in buildings or vehicles, so why put up with unabashedly defective software? It’s time to hold software vendors accountable for the quality of their products.

By Joris Evers – Microsoft warned of five vulnerabilities in its SQL Server 2000 database product, the most serious of which could allow an attacker to take over the server.