Data that seems to “disappear” has been a problem since the release of merge replication in SQL Server 7.0. Merge replication gives you the ability to process a transaction on a subscriber database and have the data propagate back to the publisher database. Such reverse propagation presents a unique

By Martin LaMonica – Microsoft Monday released enhancements to its SQL Server 2000 database to fix security holes and improve administration.

Read about the significant new features of SQL Server CE 2.0 and learn how to build a sample application for illustration.

SQL Server System Administration assumes that you are familiar with the fundamentals of database administration and have worked with SQL Server in some capacity. This book focuses on the topic of interest to most administrators: keeping data consistently available to users.

For a Microsoft Visual Basic .NET version of this article, see 306574. This article demonstrates three methods of calling a stored procedure from Active Server Pages using ActiveX Data Objects (ADO).

In addition to providing the latest updates and fixes, SQL Server 2000 SP3 includes the following benefits:<br><br> Serviceability improvements<Br> Improved multi-server administration.<Br> New monitoring API.<BR> SP3 introduces support for QLogic’s VI-enabled SANblade QLA2350 Fibre Channel cont

Brian Moran continues his discussion of Bob Ward’s recommended best practices with a look at establishing a performance baseline.

by Greg Robidoux – Many DBAs give little thought to SQL Server change management, but is this really a good idea?

Register now for Microsoft’s premier developer event for building and bringing to market wireless applications, content and services for Microsoft Windows Powered mobile devices, including Pocket PC and Smartphone.

This script extracts various details from SQL Server 7.0/2000 based on sysfiles and sysdatabases. It returns the server name, version of SQL Server, database name, device name, device location, and approximate size in MB of the device.