946) 9/29/2007 Q290624 HOWTO: Configure MSDTC in a Windows 2000 Cluster Environment (Q290624)
After you install Cluster Server on Windows 2000 Advanced Server and configure Internet Information Services (IIS) or SQL Server, you may need to manually install Microsoft Distributed Transaction Coordinator (MSDTC) as a cluster instance. 947) 9/28/2007 Q263712 INF: How to Prevent Windows NT Administrators from Administering a Clustered SQL Server (Q263712)
This article explains how you can prevent Microsoft Windows NT system administrators from having system administrator (sa) privileges in SQL Server. 948) 9/30/2007 Q264474 PRB: System Database Backups Cannot be Restored on a Different Build of SQL Server (Q264474)
You cannot restore a backup of a system database ( master , model or msdb ) on a server build that is different from the build on which the backup was originally performed. An attempt to perform such a restore causes the following error 949) 9/28/2007 Q281122 INF: Restore File and Filegroup Backups in SQL Server (Q281122)
Files or filegroups in a database can be backed up and restored individually. This allows you to restore only the damaged files without having to restore the rest of the database. Files in a filegroup backup can be restored individually or as a 950) 9/30/2007 Q288809 PRB: How to Recover SQL Server After a Tempdb Database is Marked Suspect (Q288809)
When you try to start a SQL Server service, the service may fail because the tempdb database is marked suspect. You may see the following text in the SQL Server error log: 2001-02-08 14:04:07.64 spid1 Clearing tempdb database. 951) 9/28/2007 Q319016 HOW TO: Change Domains for a SQL Server 2000 Failover Cluster (Q319016)
This step-by-step article describes the steps you must use to change domains for an existing SQL Server 2000 Failover Cluster. 952) 9/23/2007 Q321686 HOW TO: Import Data into SQL Server from Excel (Q321686)
This step-by-step article demonstrates how to import data from Microsoft Excel worksheets into Microsoft SQL Server databases by using a variety of methods. 953) 9/28/2007 Q319942 HOW TO: Determine Proper SQL Server Configuration Settings (Q319942)
This article describes the following configuration settings and considerations for their use: 954) 9/30/2007 Q314546 HOW TO: Move Databases Between Computers that are Running SQL Server (Q314546)
This step-by-step article describes how to move SQL Server user databases and most common SQL Server components between computers that are running SQL Server. 955) 9/29/2007 Q319264 PRB: Crystal Report in Web Application Fails to Log On to SQL Server (Q319264)
When you use SQL Server 2000 to obtain live data for a Crystal Report in a Visual Studio .NET Web application, the Crystal Report fails to log on to the database. This occurs even if you provide accurate credentials at design time. You rece 956) 9/27/2007 Q317428 INF: Where to Find Information About SQL Server Licensing (Q317428)
Many different variations of licensing are available for SQL Server. This article provides resources that you can use to help you decide which licensing models are appropriate for your environment. 957) 9/26/2007 Q248915 INF: How to Show Expanding Hierarchies Using SQL Server (Q248915)
Databases often store hierarchical information. For more details about hierarchical information, refer to the "Expanding Hierarchies" topic in Microsoft SQL Server Books Online. The "Expanding Hierarchies" topic has a detailed Transact-SQL 958) 9/30/2007 Q186133 INF: How to Dynamically Number Rows in a Select Statement (Q186133)
Row numbering or ranking is a typical, procedural issue. The solutions are generally based on loops and temporary tables and, therefore, SQL Server loops and cursors. This article describes how to dynamically rank rows when performing a SEL 959) 9/28/2007 Q175574 INF: How to Rotate a Table in SQL Server (Q175574)
INF: How to Rotate a Table in SQL Server The information in this article applies to: Microsoft SQL Server versions 6.0, 6.5, 7.0 Microsoft SQL Server 2000 (all editions) This article describes how you can rotate a SQL Server table. Suppose you have a table named QTRSALES with 960) 9/28/2007 Q240872 INF: How to Resolve Permission Issues When a Database is Moved Between SQL Servers (Q240872)
When you move a database from one SQL Server server to another SQL Server server, there may be a mismatch between the security identification numbers (SIDs) of the logins in the
1
2
.... .... 58
59
60
61
62
63
[ 64 ]
65
66
Previous Page
Page 64 of 66
Next Page
|