SQL links for everything


Hi Everyone

• I have summed some very good links related to SQL Server, so wanted to share these with all of you, it will definitely help us for quick references.

• Along with this, we have new People joining us pretty shortly and these would be helpful for them as well. Whenever you all have time go through this and it will help for sure

• Discussion Groups

http://www.microsoft.com/technet/newsgroups/default.asp

http://sswug.org/listservers.asp

• 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

• SQL 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

• OLE DB Programmer’s Reference

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/olpraboutthismanual.asp

• CE Main Page 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

• SQL Server 2000 Operations Guide, http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx

• 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/7.0 by Kalen Delaney, http://www.insidesqlserver.com

• The Guru’s Guide to Transact-SQL, http://www.khen.com/books.htm

• SQL Server Performance and Scalability References, http://www.microsoft.com/sql/evaluation/compare/performance.asp

• Understanding Performance Testing, http://msdn.microsoft.com/library/techart/d5dplyover.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

• 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

• 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:

• Microsoft SQL Server 2000 SP3 Security Features and Best Practices http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec00.mspx

• Securing SQL Server 2000 http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.asp

• SQL Server Security http://www.microsoft.com/technet/prodtechnol/sql/maintain/security/default.asp

• Technical Resources.Administration.Security http://www.microsoft.com/SQL/techinfo/administration/2000/security.asp

• SQL Server 2000 Security White Paper http://www.microsoft.com/technet/prodtechnol/sql/maintain/security/sql2ksec.asp

• Microsoft SQL Server 2000 Security http://www.microsoft.com/technet/prodtechnol/sql/deploy/confeat/05ppcsqa.asp

• 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

• SQL Server 2000 Operations Guide, Chapter 3–Security Administration http://www.microsoft.com/technet/prodtechnol/sql/maintain/operate/opsguide/sqlops3.asp

• SQL Server 2000 C2 Administrator’s and User’s Security Guide http://www.microsoft.com/technet/prodtechnol/sql/maintain/security/sqlc2.asp

• SQL Server 2000 Resource Kit, Chapter 10–Implementing Security http://www.microsoft.com/technet/prodtechnol/sql/reskit/sql2000/part3/c1061.asp

• 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 2000 Books Online (BOL): Managing Security, Planning Security, Security Architecture, Security Audit Event Classes, Password Protection, Authentication Modes, Replication Security, Security and Authentication Permissions
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/Default.asp

• From the list on the left choose “SQL Server” then “Maintain” then “Security”

http://www.microsoft.com/sql/techinfo/administration/2000/security.asp

http://www.microsoft.com/SQL/techinfo/administration/2000/securitywp.asp

• 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:

• 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:

• 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 and Clustering

• 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

• 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
• 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
• 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
• 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

…AarKay

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s