You run SQL Server Setup to install Microsoft SQL Server 2000 Service Pack 4 (SP4) in binary-only mode on a failover cluster. When you do this, the Setup program does not continue beyond the Services Accounts page. You receive the following error message: setup cannot verify/grant logon as servic

(Alexander Kuznetsov and Rajiv Rajak) Sometimes we developers put unnecessary burden on the server, having it perform too many sorts or sort more data than necessary. By applying the techniques described in the following sections to your design and coding practices, you’ll reduce the number of sorts

DPM 2006 cannot directly help protect a SQL Server database. Before you can use DPM 2006 to help protect the SQL Server database, you must back up the SQL Server database to a file. You must store this file on a share or on a volume that is a member of a DPM 2006 protection group. You can perform an

(Vidya Vrat Agarwal) With the release of SQL Server 7.0/2000, SQL Server Database Administrators/Developers got two great tools called SQL Server Enterprise Manager (also known as MMC) and SQL Server Query Analyzer. Enterprise Manager was designed to accomplish all the DBA tasks, whereas Query Analy

Microsoft SQL Server 2005 Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 in preparation for upgrading to SQL Server 2005. Upgrade Advisor identifies deprecated features and configuration changes that might affect your upgrade, and it provides links to documentation that des

(Vidya Vrat Agarwal) This article reveals the collaboration of .NET CLR with SQL Server 2005 and how .NET CLR generated managed code help developers to implement database objects.

(Serdar Yegulalp) Keeping SQL Server secure is not a simple matter of applying hotfixes. The self-education required to keep SQL Server safe is far reaching, covering a number of different topics. This collection of quick resources will help you understand the scope and dimension of SQL Server secur

(Douglas Reilly) I have wanted to interview Peter DeBetta ever since I read his latest book, Introducing Microsoft SQL Server 2005 for Developers . Although it’s not the only book about SQL Server on the market, I found it particularly enjoyable.

(Arthur Fuller) Even if you’ve checked out Microsoft Data Engine’s specifications, you might conclude that it’s little more than a testbed for developers on a budget. Microsoft’s documentation suggests that MSDE is useful only for a small number of users, yet many developers are pushing it far beyon

(Christian Wade) Suppose we have a recursive hierarchy stored in a relational database and we want to write it to XML. This might be for a variety of reasons – e.g. as a pre-cached input to a UI control, to export to another system using a pre-defined format, etc.