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
Other News
SQL Server 2000 Security Update for Service Pack 2
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
Microsoft Warns of SQL Server Flaws
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.
Locally Linked Infosets
The aim of this note is to propose a minimally invasive and maximally flexible mechanism for accessing Post Schema Validation Information. It was partly inspired by proposals from Rick Jelliffe (Schemachine) and Eric van del Vlist (xvif).
A Realist’s SMIL Manifesto, Part II
In the second part of his overview of SMIL 2.0, Fabio Arciniegas shows how SMIL can be used to implement common narrative strategies: condensation, synecdoche and spatial montage.
Complacency Creates Vicious Cycle of Software Bugs
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.
Copy Archive Logs
This script will copy archived redo logs to a secondary standby destination for an NT database.
Microsoft offers plug for ‘critical’ SQL Server holes
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.
Calif. Cancels Oracle Contract
By Matt Hicks – The state of California has ended its controversial enterprise licensing agreement with Oracle Corp. following months of legislative hearings and high-level resignations over a state audit report criticizing the deal.
Avoid Database Deadlocks with Planning
By Andrew Georgopulos – In this 10-Minute Solution, I discuss the controls and settings that go into transaction management and describe how to debug deadlocks by integrating resources in a manner that balances concurrency and integrity.