Useful SQL 2000 Links - Bookmarked
Please find below a consolidated list of some SQL Server 2000 links. I am sure you will not be able to accomodate all the links as part of favourites, but surely can use this page as a master link to all the interesting articles for reference.
ADO/OLEDB:
269882 HOWTO: Use ADO to Connect to a SQL Server That Is Behind a Firewall http://support.microsoft.com/?id=269882
183059 PRB: ODBC Syntax Required for Retrieving Parameter Information http://support.microsoft.com/?id=183059
229564 PRB: SQL Application Role Errors with OLE DB Resource Pooling http://support.microsoft.com/?id=229564
262447 HOWTO: Persist/Load OLE DB Rowset to/from XML with ATL OLE DB Consumer http://support.microsoft.com/?id=262447
247931 INF: Authentication Methods for Connections to SQL Server in Active http://support.microsoft.com/?id=247931
190991 HOWTO: Trap for ADO Connection Errors Using WithEvents http://support.microsoft.com/?id=190991
191572 INFO: Connection Pool Management by ADO Objects Called From ASP http://support.microsoft.com/?id=191572
237844 HOWTO: Enable ODBC Connection Pooling in a Visual Basic ADO Application http://support.microsoft.com/?id=237844
307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User http://support.microsoft.com/?id=307002
325338 OLE DB Provider for SQL Server Does Not Cancel a Batch Statement When http://support.microsoft.com/?id=325338
306216 PRB: Error "Unable to Load Communication Module" in ASP/ADO/SQL Server http://support.microsoft.com/?id=306216
253240 PRB: Errors Not Returned When Stored Procedure Statement Fails http://support.microsoft.com/?id=253240
Analysis Services
279489 INF: How to Connect to Analysis Server 2000 By Using HTTP Connection http://support.microsoft.com/?id=279489
294287 INF: How to Automate an Archive or Backup of OLAP Database http://support.microsoft.com/?id=294287
840667 PRB: Unexpected errors with ADO and ADO MD in .NET Framework applications http://support.microsoft.com/?id=840667
301901 INF: TCP Ports Used by OLAP Services when Connecting Through a Firewall http://support.microsoft.com/?id=301901
308023 HOW TO: Cluster SQL Server 2000 Analysis Services in Windows 2000 http://support.microsoft.com/?id=308023
323048 INF: Using Data Definition Language with SQL Server 2000 Analysis http://support.microsoft.com/?id=323048
322706 INF: Microsoft Corp. SQL Server Analysis Services (White Paper) http://support.microsoft.com/?id=322706
325484 Support WebCast: Introduction to XML for Analysis Services http://support.microsoft.com/?id=325484
327396 Support WebCast: Performance Tuning Analysis Services http://support.microsoft.com/?id=327396
324961 Support WebCast: Microsoft SQL Server 2000 Analysis Services: How to http://support.microsoft.com/?id=324961
828343 Support WebCast: Dynamic Dimension Security in Microsoft SQL Server 2000 http://support.microsoft.com/?id=828343
303408 INF: The Impact of Using Changing Dimensions http://support.microsoft.com/?id=303408
306990 INF: When to Create a Virtual Dimension Instead of a Physical Dimension http://support.microsoft.com/?id=306990
322596 INF: Creating Large-Scale, Highly Available OLAP Sites (White Paper) http://support.microsoft.com/?id=322596
322719 INF: Powerful and Accessible Analysis for Business (White Paper) http://support.microsoft.com/?id=322719
231951 INF: Permissions That You Must Have to Administer an OLAP Server http://support.microsoft.com/?id=231951
306408 INF: Use of Multiple Hierarchies Versus the Creation of Separate http://support.microsoft.com/?id=306408
Blocking/Deadlocks
224453 INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems http://support.microsoft.com/?id=224453
832524 SQL Server technical bulletin - How to resolve deadlocks http://support.microsoft.com/?id=832524
263889 INF: SQL Blocking Due to [[COMPILE]] Locks http://support.microsoft.com/?id=263889
75722 INF: Reducing Lock Contention in SQL Server http://support.microsoft.com/?id=75722
323630 INF: Resolving Blocking Problems That Are Caused by Lock Escalation in http://support.microsoft.com/?id=323630
295108 INF: Incomplete Transaction May Hold Large Number of Locks and Cause http://support.microsoft.com/?id=295108
317375 INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server http://support.microsoft.com/?id=317375
324885 Support WebCast: Microsoft SQL Server: Rapid Blocker Script Analysis http://support.microsoft.com/?id=324885
215520 INFO: COM+ and MTS Always Use SERIALIZABLE Transaction Isolation Level http://support.microsoft.com/?id=215520
48712 INF: Handling Timeouts Correctly in DB-Library http://support.microsoft.com/?id=48712
CE:
325229 Support WebCast: Microsoft SQL Server 2000 Windows CE Edition Overview http://support.microsoft.com/?id=325229
273580 HOWTO: Look Up Error Codes Related to SQL Server CE http://support.microsoft.com/?id=273580
814852 INF: How to Enable Encryption Support for SQL Server CE Databases http://support.microsoft.com/?id=814852
320785 HOW TO: Create a Database, a Table, and Run a Query (SQL Server CE http://support.microsoft.com/?id=320785
279552 HOWTO: Delete a SQL Server CE Database in an Application http://support.microsoft.com/?id=279552
279761 HOWTO: Use the ADOCE 3.1 Seek Method with SQL Server CE http://support.microsoft.com/?id=279761
814851 FIX: SQL Server CE Application Fails on Pocket PC 2002 Emulator on http://support.microsoft.com/?id=814851
272210 INFO: System Tables in SQL Server CE Database http://support.microsoft.com/?id=272210
274112 INFO: SQL Server CE Performance Tips and Efficient Memory Handling http://support.microsoft.com/?id=274112
276985 HOWTO: Use SQL Server CE OLE DB Provider-Specific Properties in eVB http://support.microsoft.com/?id=276985
325818 PRB: SQL Server CE 2.0 in Visual Studio .NET 2003 Does Not Support http://support.microsoft.com/?id=325818
301217 HOW TO: Prebuild a Database in SQL Server CE http://support.microsoft.com/?id=301217
814850 INF: Compacting a SQL Server 2000 CE Database by Using Visual Basic .NET http://support.microsoft.com/?id=814850
330971 SQL Server 2000 Windows CE Edition 2.0 for Visual Studio .NET 2003 http://support.microsoft.com/?id=330971
304058 HOWTO: Perform Replication by Using SSCERelay and ActiveSync http://support.microsoft.com/?id=304058
SQL CE FAQ http://support.microsoft.com/default.aspx?scid=/support/sql/content/sqlce/sqlcefaq.asp
CE Main Page http://www.microsoft.com/sql/CE/default.asp <blocked::blocked::http://www.microsoft.com/sql/CE/default.asp>
SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices
http://msdn.microsoft.com/msdnmag/issues/01/06/sqlce/default.aspx
Troubleshooting Microsoft SQL Server 2000 Windows CE Edition Connectivity Issues
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlce/html/sqlce_troubleconnect.asp
Pocket PC 2002 SDK
http://www.microsoft.com/downloads/details.aspx?FamilyId=2DBEE84A-BD94-4167-B817-2B2E548B2E92&displaylang=en
323143 FIX: SQL Server CE Is Missing Oledb.lib File for eMbedded Visual C++ 4.0 http://support.microsoft.com/?id=323143
Clustering:
SQL Server Books Online (BOL)
SQL Server 2000 Clustering Whitepaper, http://www.microsoft.com/SQL/techinfo/administration/2000/failovercluster.asp
815431 PRB: Installation of a Named Instance of SQL Server 2000 Virtual Server http://support.microsoft.com/?id=815431
327322 PRB: SQL Server 2000 Enterprise Manager Polling May Cause ClientToken http://support.microsoft.com/?id=327322
325485 WebCast: Microsoft SQL Server 2000 Virtual Server Basic Setup http://support.microsoft.com/?id=325485
274446 INF: Upgrade to SQL Server 2000 Failover Solution Recommended for All.... http://support.microsoft.com/?id=274446
233332 INF: How To Run SQLDIAG On a Clustered/Virtual SQL Server http://support.microsoft.com/?id=233332
254321 INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings http://support.microsoft.com/?id=254321
243218 INF: Installation Order for SQL Server 2000 Enterprise Edition http://support.microsoft.com/?id=243218
260758 INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering http://support.microsoft.com/?id=260758
319723 INF: Kerberos Support for SQL Virtual Servers on Server Clusters http://support.microsoft.com/?id=319723
307336 INF: How to Change a Clustered SQL Server Network Name http://support.microsoft.com/?id=307336
239885 INF: How to Change Service Accounts on a SQL Virtual Server http://support.microsoft.com/?id=239885
244980 HOWTO: Change the Network IP Addresses on a Virtual SQL Server http://support.microsoft.com/?id=244980
319016 HOW TO: Change Domains for a SQL Server 2000 Failover Cluster http://support.microsoft.com/?id=319016
304282 PRB: Full Text Resource Fails to Come Online on a Cluster with "Event ID... http://support.microsoft.com/?id=304282
270126 PRB: How to Manage Client Connectivity to Both SQL Server 2000 Virtual http://support.microsoft.com/?id=270126
298723 BUG: SQL Mail Not Fully Supported for Use in Conjunction with Cluster http://support.microsoft.com/?id=298723
815431 PRB: You Cannot Successfully Install a Named Instance of SQL Server 2000 http://support.microsoft.com/?id=815431
305793 How to Replace a Disk That Is on a Windows 2000 or a Windows 2003 Server http://support.microsoft.com/?id=305793
216964 How to Administer a Server Cluster Remotely http://support.microsoft.com/?id=216964
168801 How to Turn On Cluster Logging in Microsoft Cluster Server http://support.microsoft.com/?id=168801
278007 Available Features in Windows Server 2003 Clusters http://support.microsoft.com/?id=278007
258750 Recommended Private "Heartbeat" Configuration on a Cluster Server http://support.microsoft.com/?id=258750
Connectivity:
812817 Support WebCast: Microsoft SQL Server 2000: Troubleshooting Connectivity http://support.microsoft.com/?id=812817
324608 Support WebCast: Troubleshooting Database Connectivity Issues in http://support.microsoft.com/?id=324608
270126 PRB: How to Manage Client Connectivity to Both SQL Server 2000 Virtual http://support.microsoft.com/?id=270126
138541 HOW TO: Odbcping.exe to Verify ODBC Connectivity to SQL Server http://support.microsoft.com/?id=138541
293107 PRB: TCP\IP Port in Use by Another Application http://support.microsoft.com/?id=293107
328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access http://support.microsoft.com/?id=328306
811889 HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message http://support.microsoft.com/?id=811889
Disaster Recovery:
325257 Support WebCast: SQL Server 2000 Database Recovery: Backup and Restore http://support.microsoft.com/?id=325257
Designing a Backup and Restore Strategy, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_63eh.asp
829024 INFO: Microsoft SQL Server 2000 Operations Guide http://support.microsoft.com/?id=829024
307775 INF: Disaster Recovery Articles for Microsoft SQL Server http://support.microsoft.com/?id=307775
321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log Backups http://support.microsoft.com/?id=321836
DTS:
269074 INF: How to Run a DTS Package as a Scheduled Job http://support.microsoft.com/?id=269074
316043 HOW TO: Log Data Transformation Services Package Execution to a Text File http://support.microsoft.com/?id=316043
240221 HOW TO: Handle Errors in Data Transformation Services "Package" and.... http://support.microsoft.com/?id=240221
221193 HOW TO: Install Data Transformation Services (DTS) Event Handlers in.... http://support.microsoft.com/?id=221193
241249 HOW TO: Obtain a List of DTS Packages http://support.microsoft.com/?id=241249
249236 HOW TO: Return Multiple Columns in a DTS Lookup Query http://support.microsoft.com/?id=249236
315661 HOW TO: Run a SQL Server Data Transformation Services Package from.... http://support.microsoft.com/?id=315661
319951 HOW TO: Transfer Data to Excel by Using SQL Server Data Transformation http://support.microsoft.com/?id=319951
323685 HOW TO: Troubleshoot DTS Packages That You Run from Visual Basic http://support.microsoft.com/?id=323685
321525 HOW TO: Use DTS Package Events in Visual Basic .NET http://support.microsoft.com/?id=321525
242543 INF: DTS Row Level Restartability After an Unexpected Failure http://support.microsoft.com/?id=242543
239454 INF: ScriptPkg Tool Generates DTS Object Model Code to Help Use DTS http://support.microsoft.com/?id=239454
286124 INF: How to Reschedule a DTS Package http://support.microsoft.com/?id=286124
252987 INF: Execute a SQL Server DTS Package from Active Server Pages http://support.microsoft.com/?id=252987
http://www.sqldts.com (not a Microsoft affiliated site)
Log Shipping:
314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping http://support.microsoft.com/?id=314515
323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White Paper) http://support.microsoft.com/?id=323135
325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping http://support.microsoft.com/?id=325220
821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping http://support.microsoft.com/?id=821786
321247 HOW TO: Configure Security for Log Shipping http://support.microsoft.com/?id=321247
329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync" Errors http://support.microsoft.com/?id=329133
Move a Database:
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server http://support.microsoft.com/?id=314546
224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach http://support.microsoft.com/?id=224071
221465 INF: Using the WITH MOVE Option with the RESTORE Statement http://support.microsoft.com/?id=221465
240872 HOW TO: Resolve Permission Issues When You Move a Database Between http://support.microsoft.com/?id=240872
246133 INF: How To Transfer Logins and Passwords Between SQL Servers http://support.microsoft.com/?id=246133
274463 INF: Understanding and Troubleshooting the Copy Database Wizard in SQL http://support.microsoft.com/?id=274463
168001 PRB: User Logon and/or Permission Errors After Restoring Dump http://support.microsoft.com/?id=168001
264474 PRB: System Database Backups Cannot be Restored on a Different Build of http://support.microsoft.com/?id=264474
321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log Backups http://support.microsoft.com/?id=321836
MSDE:
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) http://www.microsoft.com/sql/msde
815013 HOWTO: Upgrade an Instance of Microsoft SQL Server 2000 Desktop Engine http://support.microsoft.com/?id=815013
325023 INFO: Upsize SQL Server 2000 Desktop Engine to SQL Server http://support.microsoft.com/?id=325023
325003 HOW TO: Manage the SQL Server Desktop Engine (MSDE 2000) by Using the http://support.microsoft.com/?id=325003
321518 INFO: When to Choose MSDE 2000 as the Database Engine for Your http://support.microsoft.com/?id=321518
324998 HOW TO: Obtain and Install SQL Server 2000 Desktop Engine (MSDE 2000) http://support.microsoft.com/?id=324998
241397 HOWTO: Back Up a Microsoft Data Engine Database with Transact-SQL http://support.microsoft.com/?id=241397
817788 Support WebCast: Microsoft SQL Server 2000 Desktop Engine (MSDE) http://support.microsoft.com/?id=817788
285097 INF: How to Change the Default Login Authentication Mode to SQL While http://support.microsoft.com/?id=285097
328747 INF: Recovery Planning for Microsoft SQL Server 2000 Desktop Engine http://support.microsoft.com/?id=328747
319930 HOW TO: Connect to Microsoft Desktop Engine http://support.microsoft.com/?id=319930
325022 INFO: MSDE Security and Authentication http://support.microsoft.com/?id=325022
318124 HOW TO: Set Up Development Environment from MSDN Professional http://support.microsoft.com/?id=318124
322336 HOW TO: Verify and Change the MSDE System Administrator Password http://support.microsoft.com/?id=322336
Performance References:
Inside SQL Server 2000 by Kalen Delaney http://www.insidesqlserver.com
The Guru's Guides (Transact-SQL, Architecture and Internals, Stored Procedures and XML) http://www.khen.com/books.htm
224587 INF: Troubleshooting Application Performance with SQL Server http://support.microsoft.com/?id=224587
243586 INF: Troubleshooting Stored Procedure Recompilation http://support.microsoft.com/?id=243586
298475 INF: Information Required to Successfully Troubleshoot Application http://support.microsoft.com/?id=298475
175658 How To Gather Information for Effective Troubleshooting of Performance http://support.microsoft.com/?id=175658
319942 HOW TO: Determine Proper SQL Server Configuration Settings http://support.microsoft.com/?id=319942
297864 INF: Performance Considerations for an Upgrade from SQL Server 6.5 http://support.microsoft.com/?id=297864
314648 INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO http://support.microsoft.com/?id=314648
311826 INF: Index Tuning Wizard Best Practices http://support.microsoft.com/?id=311826
Index Tuning Wizard 2000, http://msdn.microsoft.com/library/techart/itwforsql.htm
Index Tuning Wizard 7.0, http://msdn.microsoft.com/library/techart/msdn_sqlindex.htm
Troubleshooting the Index Tuning Wizard, http://msdn.microsoft.com/library/psdk/sql/tr_servtools_48ro.htm
195565 INF: How SQL Server 7.0 and SQL Server 2000 Autostats Work http://support.microsoft.com/?id=195565
197297 INF: Comparison of Join Techniques http://support.microsoft.com/?id=197297
324692 Support WebCast: How to Collect and Analyze Performance Data in http://support.microsoft.com/?id=324692
325263 Support WebCast: SQL Server 2000 Profiler: What's New and How to http://support.microsoft.com/?id=325263
815337 Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans in http://support.microsoft.com/?id=815337
283886 HOW TO: View SQL Server 2000 Performance Data http://support.microsoft.com/?id=283886
139609 PerfMon: High Number of Pages/Sec Not Necessarily Low Memory http://support.microsoft.com/?id=139609
268343 Umdhtools.exe: How to Use Umdh.exe to Find Memory Leaks http://support.microsoft.com/?id=268343
286350 HOWTO: Use Autodump+ to Troubleshoot "Hangs" and "Crashes" http://support.microsoft.com/?id=286350
316365 INFO: ROADMAP for How to Use the .NET Performance Counters http://support.microsoft.com/?id=316365
150934 How to Create a Performance Monitor Log for NT Troubleshooting http://support.microsoft.com/?id=150934
130926 Using Performance Monitor to Identify a Pool Leak http://support.microsoft.com/?id=130926
146005 Optimizing Windows NT for Performance http://support.microsoft.com/?id=146005
248345 How to Create a Log Using System Monitor in Windows 2000 http://support.microsoft.com/?id=248345
275685 INF: Importing Performance Monitor Logs into SQL Server http://support.microsoft.com/?id=275685
Replication:
Replication Overview http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replover_694n.asp
315642 INF: Information That PSS Needs to Troubleshoot SQL Server Replication http://support.microsoft.com/?id=315642
312292 HOW TO: Enable Replication Agents for Logging to Output Files in SQL http://support.microsoft.com/?id=312292
321822 HOW TO: Replicate Between Computers Running SQL Server in Non-Trusted http://support.microsoft.com/?id=321822
320499 HOW TO: Manually Synchronize Replication Subscriptions by Using Backup http://support.microsoft.com/?id=320499
320123 HOW TO: Add Columns in a Rollup Subscriber Topology http://support.microsoft.com/?id=320123
321176 HOW TO: Set Up Alternate Synchronization Partner in SQL Server 2000 http://support.microsoft.com/?id=321176
323046 INF: Transactional Replication Performance Tuning and Optimization http://support.microsoft.com/?id=323046
322324 INF: Transactional Replication Performance Tuning and Optimization http://support.microsoft.com/?id=322324
241149 INF: How to Automate Replication over a Dial-Up Connection http://support.microsoft.com/?id=241149
291001 INF: How to Use sp_scriptdynamicupdproc to Improve the Performance of http://support.microsoft.com/?id=291001
305127 PRB: How to Generate a Snapshot of a Published Table and Apply It to the http://support.microsoft.com/?id=305127
285106 PRB: SQL Server Enterprise Manager Reports That the Replication Agent Is http://support.microsoft.com/?id=285106
304535 PRB: ANSI Warnings May Incorrectly Show Replication Agents As Failed http://support.microsoft.com/?id=304535
301217 HOW TO: Prebuild a Database in SQL Server CE http://support.microsoft.com/?id=301217
324992 HOW TO: Use Replication with SQL Server 2000 Desktop Engine (MSDE 2000) http://support.microsoft.com/?id=324992
303789 INFO: Using MSDE 2000 With SQL Server CE RDA and Replication http://support.microsoft.com/?id=303789
Merge Replication
322233 INF: Diagnosing and Troubleshooting Slow Partitioned Merge Replication http://support.microsoft.com/?id=322233
325120 Support WebCast: Microsoft SQL Server 2000: Merge Replication http://support.microsoft.com/?id=325120
315521 INF: How to Troubleshoot SQL Server Merge Replication Problems http://support.microsoft.com/?id=315521
322910 INF: Managed Range Identities in Merge Replication http://support.microsoft.com/?id=322910
307356 INF: Understanding Merge Replication Article Processing Order http://support.microsoft.com/?id=307356
315514 INF: Understanding Merge Replication Conflict Detection and Resolution http://support.microsoft.com/?id=315514
319646 HOW TO: Program the SQL Merge Control by Using Visual C# .NET http://support.microsoft.com/?id=319646
309400 FIX: Merge Replication Non-Convergence Fixes in SQL Server 2000 SP2 http://support.microsoft.com/?id=309400
Security:
Security Resources http://www.microsoft.com/sql/techinfo/administration/2000/security/default.asp
10 Steps to Help Secure SQL Server 2000 http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.asp 322712 Microsoft SQL Server 2000 SP3 Security Features and Best Practices http://support.microsoft.com/?id=322712
SQL Server 2000 Administrator's Pocket Consultant: SQL Server 2000 Security http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c05ppcsq.mspx
813944 SQL Server 2000 Security Tools http://support.microsoft.com/?id=813944
309422 INF: Consideration for a Virus Scanner on a Computer That Is Running SQL http://support.microsoft.com/?id=309422
829024 INFO: Microsoft SQL Server 2000 Operations Guide http://support.microsoft.com/?id=829024
SQL Server 2000 C2 Administrator's and User's Security Guide http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx
SQL Server 2000 Resource Kit, Chapter 10--Implementing Security http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1061.mspx
817384 HOWTO: Use Kerberos Authentication for Microsoft SQL Server 2000 http://support.microsoft.com/?id=817384
Troubleshooting Kerberos Delegation White Paper http://www.microsoft.com/downloads/details.aspx?FamilyID=99b0f94f-e28a-4726-bffe-2f64ae2f59a2&displaylang=en
811889 How to troubleshoot the "Cannot generate SSPI context" error message http://support.microsoft.com/?id=811889
Download the latest version of books online: (303839 Updates to SQL Server Books Online for SQL Server 2000 http://support.microsoft.com/?id=303839 ). Sample topics from SQL Server 7.0/2000 Books Online (BOL): Managing Security, Planning Security, Security Architecture, Security Audit Event Classes, Password Protection, Authentication Modes, Replication Security, Security and Authentication Permissions
SQL Mail:
321183 HOW TO: Troubleshoot Your SQL Mail Issue http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail http://support.microsoft.com/?id=311231
263556 INF: How to Configure SQL Mail http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems http://support.microsoft.com/?id=315886
Per SQL Server 2000 Books Online: "SQL Server uses two services to handle mail. MSSQLServer processes mail for all of the mail stored procedures. SQLServerAgent does not use SQL Mail to send e-mail. Instead, SQLServerAgent uses its own mail capabilities that are configured and operated separately from SQL Mail."
Per SQL Server 2000 Books Online regarding the DTS Send Mail task (which does not use SQL Mail or SQL Agent Mail): "With the Send Mail task, you can send an e-mail message as a task. For example, if you want to notify a database administrator about the success or failure of a backup operation, you can link a Send Mail task to the preceding backup task. To use a Send Mail task, you need to install MAPI with a valid user profile on the instance of Microsoft® SQL Server(tm) you are running."
SSL Encryption:
314636 FIX: Cannot Use Non-Administrator Account to Start SQL Server and Force.... http://support.microsoft.com/?id=314636
276553 HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate Server http://support.microsoft.com/?id=276553
322144 SECDoClientHandShake Cannot Connect to SQL Server http://support.microsoft.com/?id=322144
257591 Description of the Secure Sockets Layer (SSL) Handshake http://support.microsoft.com/?id=257591
316898 HOW TO: Enable SSL Encryption for SQL Server 2000 with Microsoft.... http://support.microsoft.com/?id=316898
324777 WebCast: Microsoft SQL Server 2000: How to Configure SSL Encryption http://support.microsoft.com/?id=324777
318605 INF: How SQL Server Uses a Certificate When the Force Protocol http://support.microsoft.com/?id=318605
325757 INF: Using SQL Server 2000 with FIPS 140-1 Ciphers http://support.microsoft.com/?id=325757
302409 FIX: Unable to Connect to SQL Server 2000 When Certificate Authority.... http://support.microsoft.com/?id=302409
311111 FIX: RPC Clients Unable to Login to SQL Server with Windows.... http://support.microsoft.com/?id=311111
Stored Procedures:
The Guru's Guides (Transact-SQL, Architecture and Internals, Stored Procedures and XML) http://www.khen.com/books.htm
262499 INF: Using Output Parameters with sp_executesql http://support.microsoft.com/?id=262499
183001 Retrieving Output Parameters From Stored Procedure http://support.microsoft.com/?id=183001
152174 INF: Output Parameters, Return Codes and the ODBC Driver http://support.microsoft.com/?id=152174
811482 INF: Handling SQL Server Error Messages When a Stored Procedure is Used http://support.microsoft.com/?id=811482
321903 HOW TO: Return Errors and Warnings from a SQL Server Stored Procedure in http://support.microsoft.com/?id=321903
321902 HOW TO: Call Stored Procedures with Optional Values in ADO.NET http://support.microsoft.com/?id=321902
300488 HOWTO: Run SQL Server Stored Procedures from an ASP Page http://support.microsoft.com/?id=300488
245179 HOWTO: Process Multiple Recordsets and Messages in ADO http://support.microsoft.com/?id=245179
306574 HOW TO: Call SQL Server Stored Procedures in ASP.NET by Using Visual http://support.microsoft.com/?id=306574
310070 HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and http://support.microsoft.com/?id=310070
310130 HOW TO: Execute SQL Parameterized Stored Procedures by Using the ODBC http://support.microsoft.com/?id=310130
311274 HOW TO: Handle Multiple Results by Using the DataReader in Visual C# .NET http://support.microsoft.com/?id=311274
310650 INFO: Known Issues with the Visual Basic T-SQL Debugger and SQL Server http://support.microsoft.com/?id=310650
243428 HOW TO: Move Extended Stored Procedures Out of Process http://support.microsoft.com/?id=243428
Transaction Logs:
873235 How to stop the transaction log of a SQL Server database from growing http://support.microsoft.com/?id=873235
317375 INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server http://support.microsoft.com/?id=317375
272318 INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC http://support.microsoft.com/?id=272318
256650 INF: How to Shrink the SQL Server 7.0 Transaction Log http://support.microsoft.com/?id=256650
315512 INF: Considerations for Autogrow and Autoshrink Configuration http://support.microsoft.com/?id=315512
307487 HOW TO: Shrink the Tempdb Database in SQL Server http://support.microsoft.com/?id=307487
281122 INF: Restore File and Filegroup Backups in SQL Server http://support.microsoft.com/?id=281122
303229 PRB: Transaction Log Backup Job Created with Database Maintenance http://support.microsoft.com/?id=303229
321836 HOW TO: Retrieve a Table or Rows from Database or Transaction Log Backups http://support.microsoft.com/?id=321836
272093 INF: Effects of Nonlogged and Minimally Logged Operations on Transaction http://support.microsoft.com/?id=272093
286280 INF: Effect of Database File Additions or Deletions on Database Recovery http://support.microsoft.com/?id=286280
230785 INF: SQL Server 7.0 and SQL Server 2000 Logging and Data Storage http://support.microsoft.com/?id=230785
Transaction Units:
317375 INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server http://support.microsoft.com/?id=317375
198024 INFO: Understanding ADO Transactions with MS SQL Server http://support.microsoft.com/?id=198024
238163 HOWTO: Implement Nested Transactions with ADO and SQL Server http://support.microsoft.com/?id=238163
295108 INF: Incomplete Transaction May Hold Large Number of Locks and Cause http://support.microsoft.com/?id=295108
295027 INF: Limited Support for Savepoint in Distributed Transactions in SQL http://support.microsoft.com/?id=295027
Windows 2003
815431 PRB: Installation of a Named Instance of SQL Server 2000 Virtual Server http://support.microsoft.com/?id=815431
329329 PRB: Windows Server 2003 Support for SQL Server 2000 http://support.microsoft.com/?id=329329
815430 INF: How to Suppress the Appshelp Message in an Unattended Installation http://support.microsoft.com/?id=815430
817064 HOW TO: Enable Network DTC Access in Windows Server 2003 http://support.microsoft.com/?id=817064
301520 SQL Server 2000 Cluster Does Not Install on Windows Server 2003-Based http://support.microsoft.com/?id=301520
313037 INF: Upgrading SQL Server Clusters to Windows Server 2003 http://support.microsoft.com/?id=313037
327270 SQL Server 2000 Is Not Supported on Windows Server 2003 Terminal Server http://support.microsoft.com/?id=327270
811430 INF: SQL Server 2000 Supports IPSec on Windows Server 2003 Cluster http://support.microsoft.com/?id=811430
281662 Windows 2000 and Windows Server 2003 Cluster Nodes As Domain Controllers http://support.microsoft.com/?id=281662
Windows Server 2003 Clustering Services http://www.microsoft.com/windowsserver2003/technologies/clustering/default.mspx 821751 INFO: Availability of Windows Server 2003 COM+ 1.5 Rollup Package 1 http://support.microsoft.com/?id=821751
Courtesy: Deepak C (PFE Team, Microsoft)