SQL Server: Common Problems, Tested Solutions

Microsoft SQL Server is the most popular database management system (DBMS) for the Windows NT and Windows 2000 platform. It is also one of the foundation servers in Microsoft’s Windows DNA and the forthcoming .NET framework. This book will help the professional programmer get up to speed on a key Microsoft technology. This book consists of nearly 500 common and not-so-common questions and problems that users of all version of SQL Server are likely to come across. The solutions to these problems are either undocumented or poorly documented in Microsoft’s own literature. Some answers are very short – others pretty extensive, depending on the question. As many possible answers or ways of doing things are given. Again, the book covers all versions of MS SQL Server. Pike began working on the content for this book as a time saving device for his own personal use. He would use it himself to save himself time when answering questions on Microsoft’s support newsgroups, Compuserve forums, and SQL list servers. Over the last few years, Pike has expanded it to include entries submitted by other experts – mainly other SQL Server MVPs (Microsoft Valued Professionals) like Pike himself. Many solutions fit into more than one category, so they are listed in their primary category section, but are also cross-referenced. The book’s index and cross-references allow the reader to easily locate related solutions in separate sections as necessary.

Table of Contents

\*About the Technical Editors \*Foreword \*Application Design and Programming \*Connectivity \*Database Administration \*DTS \*Installation and Upgrades \*Miscellaneous \*OLAP \*Security \*Server Administration and Tools \*Troubleshooting \*Subject Index \*Question Index