By Joseph F. Kovar & Paula Rooney – Microsoft has doled out another change to its Software Assurance maintenance policy designed to ease the financial burden on those who wish to move from standard editions of Windows and application servers to enterprise servers. At Gartner’s Software Asset

Review by Vyas Kondreddi – This book is completely focused towards helping aspiring DBAs and database developers. It has answers for all those questions that generally trouble a budding DBA. Shows you how to setup an SQL Server, administer it, secure it and develop database code.

By Jeannine Hall Gailey – When you use ActiveX controls along with the administration functionality that SQL-DMO provides, you can programmatically administer, customize, and control an entire replication topology.

By Margie Semilof – At the TechEd conference earlier this month, IT executives picked up a few details about Microsoft’s database strategy. First, the company said it would add reporting services for SQL Server 2000; they will appear sometime later this year. And, second, officials said that Microso

Alexander Chigrik explains how to move a database, or database file to another server or disk using sp_detach_db and sp_attach_db system stored procedures to detach the database and then attach it again.

From SQLTeam – This article comes to us from Cory Koski. Cory writes “I recently had the problem of trying to search for a regular expression in a database field. There is no version of SQL Server that supports regular expressions natively, but I discovered a way to add all sorts of regular expressi

This article describes the limitations of Transact-SQL Debugger in SQL Server 2000. This article also provides guidelines and directions to troubleshoot basic problems related to Transact-SQL Debugger. However, this is not an exhaustive list, and some problems may be specific to your environment.

Since the publication of the SQL Server 2000 Service Pack 3a (SP3a) readme file, several items have been changed.

Running an OpenXML statement in SQL Server 2000 returns an XML data stream back to the client. This article contains a sample that prints the contents of the XML document back to the client application through an ADODB.Recordset.

Learn through this SQL Server Magazine article how to use SQL Analysis Services together with Office Web Components to build a Web-based analysis system.