I built a Data Transformation Services (DTS) package that exports data from a table in SQL Server 7.0 to a spreadsheet in Microsoft Excel. The package’s first run works fine, but subsequent runs just append the data to the spreadsheet instead of replacing it in the spreadsheet. How can I avoid this

In this article Sancho Fock discusses various strategies for reducing blocking in SQL Server databases.

Neil Boyle shares a checklist of 24 common security gaps. Don’t let your server fall under any of these lapses. You’ve been warned.

In addition to processor speed, Andrew Zanevsky, a Chicago-based SQL Server consultant, comes to Brian Moran with another important factor to consider when selecting a server–SQL Server licensing costs.

Microsoft is to support development of XML-based websites in Office FrontPage 2003 and extend SQL Server database capabilities to more than 50 proprietary databases and files.

SQL Server Magazine’s Rich Rollman continues his Web services tutorial for SQL developers, showing you how to integrate your new Web service into an application.

by David Stodder – The race is on between DBMS and tool providers to see who can “self-heal” the database first.

Microsoft has released SQL Server 2000 Service Pack 3a (SP3a) to address specific issues discovered in SQL Server 2000 since its ship date. Because SQL Server service packs are cumulative, SP3a includes all fixes from SP1, SP2, and SP3. However, if you’ve applied SP3, Microsoft says you don’t need t

Convert your stored procedures to Web services in SQLXML with instruction from this SQL Server Magazine article by Rich Rollman.

This article guides you through the steps of installing SQL Server 2000 for Windows CE.