Controlling SQL Server Settings

Change control in SQL Server isn't the strong point of the product. And change control of server based settings is something that you might not worry about, but which can easily cause you hours of troubleshooting time. Author Andre Vigneau deploys software to other companies and has developed a solution to deal with this problem. Read on and get some code that can help you prevent or at least fix any changes to SQL Server sp_configure parameters.

Which of the following is equivalent to executing...

You create a maintenance plan on SQL2000 and...

Exploring SQL Server 2000 Configuration Properties

The SQL Server tools are top notch and often other platforms attempt to duplicate their handiness. Enterprise Manager is one that every DBA uses and it can perform a myriad of functions to configure your server. Read this new article by Dale Elizabeth Corey that looks that the wide range of items in the Configuration Properties of this tool.

What does ACID stand for?

Sending SQL Notifications with CDOSYS

SQL Server has a nice alert system, but SQLMail leaves something to be desired. New author Desiree Harris, from hosting provider Orcsweb, looks at an alternative method for sending alerts using an SMTP server and without requiring Outlook to be installed.

Changing Domains for a SQL Server 2000 Failover Cluster

This step-by-step article describes the steps you must use to change domains for an existing SQL Server 2000 Failover Cluster.

You are using SQL Server 2000 SP3. You...

What is the Maximum number of tables and...

Troubleshooting and Debugging SQL Web Services Configurations

A Q&A look at the new Web Services configurations in SQL Server 2005.