Answer provided by Amar Nalla – The SQLXML 3.0 install may fail on machines that have MDAC 2.7 installed on them. If this happens you can check the value for the following registry key:

by Mark Friedman – In this article I’ve provided answers to the most frequently asked questions I’ve received from experienced computer performance professionals. What I’ve found is when these professionals first start to look seriously at the data available on disk performance on a Windows NT/2000/

SQL Server 2000’s Enterprise Manager contains a scripting tool that you can use to extract basic index drop and create commands. However, to create such a script you’ll have to painstakingly cut and paste, and the result will not have any error checking. In this article you’ll see how to construct S

SQL Server has no built-in mechanism to prohibit duplicates except NULLs, so you need to implement a custom CHECK constraint to enforce this restriction. For example, the following code snippet enforces the kind of integrity you’re looking for.

By Lisa Vaas – BMC Software Inc. on Monday plans to announce new SmartDBA data management tools for Microsoft Corp. SQL Server databases.

by Randy Dyess – If you don’t have the ability to easily manage the jobs on your SQL Server, then you may want to consider writing your own SQL Server job management system, like the one described in this article.

By Sanders Kaufman, Jr. – Aside from the obvious difference of price, what distinguishes these two products from each other, and how do you choose between them? Let’s take a look at the core differences between these two products, including licensing costs, performance, and security.

By Barbara Darrow – The upcoming Microsoft System Center will meld capabilities to be offered by the company’s upcoming Systems Management Server 2003 and Microsoft Operations Manager 2004 into an enterprise-ready systems management suite, executives said Monday.<Br><br>MOM 2004 will also provide ne

ClearData Consulting offers a one-day audit of your Microsoft SQL Servers to ensure secure, efficient systems. Our consultants will come on-site to monitor your system, perform system tests and interview your staff to look for possible ways to improve in the following areas:

From SQL Magazine – Readers give advice about configuring the Client Access ODBC driver for DTS data transfer between the AS/400 and SQL Server and ask about concurrent security role limits in Analysis Services.