Useful SQL 2000 Links – Bookmarked April 25th, 2006

Vinod Kumar

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)

Tags:

This entry was posted on Tuesday, April 25th, 2006 at 20:45 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.


2 Responses to “Useful SQL 2000 Links – Bookmarked”

  1. Sudeepta says:

    Sir, All the information, I am looking about SQL Server 2000, All in one place :) Thanks for these links, Sir !!

Leave a Reply