http://www.sqlservercentral.com/Content tagged Basic Querying, Configuring, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you. http://www.sqlservercentral.com/articles/Administering/qa2k_3/740/2005/01/07http://www.sqlservercentral.com/articles/Administering/qa2k_3/740/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods. http://www.sqlservercentral.com/articles/Service+Packs/versionservicepack/928/2003/02/28http://www.sqlservercentral.com/articles/Service+Packs/versionservicepack/928/This article explains how to use a simple batch file and script file to manage multiple databases on multiple servers. http://www.sqlservercentral.com/articles/Configuring/osql/831/2002/10/24http://www.sqlservercentral.com/articles/Configuring/osql/831/The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server. http://www.sqlservercentral.com/articles/Configuring/ansioptionspart3ansi_null_dflt_on/736/2002/08/07http://www.sqlservercentral.com/articles/Configuring/ansioptionspart3ansi_null_dflt_on/736/In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you. http://www.sqlservercentral.com/articles/Administering/qa2k_3/740/2005/01/07http://www.sqlservercentral.com/articles/Administering/qa2k_3/740/The behavior of SQL Server is influenced in many ways by the various settings and options available. This series will examine some of the ANSI options that can be set and changed in SQL Server. http://www.sqlservercentral.com/articles/Configuring/ansioptionspart1ansi_padding/723/2002/07/08http://www.sqlservercentral.com/articles/Configuring/ansioptionspart1ansi_padding/723/Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now! http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/2002/06/04http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/