886) 9/28/2007 Q822101 INF: The waittype and lastwaittype Fields in the sysprocesses Table
(822101) - This article lists the possible lastwaittype values, their associated waittype values, and a brief description of their meaning. 887) 9/27/2007 Q325815 INF: Using SqlCeDataReader with SQL Server CE 2.0 in Visual Basic .NET
(325815) - You can use the SqlCeDataReader class to read a forward-only stream of data rows from a data source. To use the SqlCeDataReader class, you must include a reference to the System.Data.SqlServerCe namespace. The SQlCeDataReader class is an alternative... 888) 9/23/2007 Q239530 INF: Unicode String Constants in SQL Server Require N Prefix
(239530) - When dealing with Unicode string constants in SQL Server you must precede all Unicode strings with a capital letter N, as documented in the SQL Server Books Online topic "Using Unicode Data". The "N" prefix stands for National Language in the SQL-92... 889) 9/23/2007 Q814576 INF: How to Consolidate Physical Files and Rename the Logical File Name of a Database in SQL Server 2000
In SQL Server 2000, you can add, delete, and rename the data files and the transaction log files. This article explains how to consolidate physical files, and how to rename the logical file name in SQL Server 2000. 890) 9/29/2007 Q811891 PRB: SQL Server Only Uses Two GB of Memory Even Though the AWE Option is Enabled
SQL Server only uses 2 gigabytes (GB) of memory even though SQL Server is configured to use the Microsoft Windows 2000 Address Windowing Extensions (AWE) API to support a maximum of 64 GB of physical memory when the awe enabled option is set to 1.... 891) 9/29/2007 Q307197 PRB: SQL Virtual Cluster Server Fails to Bind to the Port on Which it is Listening
When you fail over the SQL Virtual Server to another node and then fail back to the original node, SQL Virtual Server sometimes fails to bind to the port on which it is listening. SQL Virtual Server then also fails to accept incoming connections on... 892) 9/21/2007 Q288577 INF: Troubleshooting Database Maintenance Plan Failures
If any task in a Database Maintenance plan fails or encounters an error message, the maintenance plan job itself may show as failed. The Job History Details shows the following error message: sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. However, this does not necessarily 893) 9/28/2007 Q315521 INF: How to Troubleshoot SQL Server Merge Replication Problems
This article serves as a basic guide for troubleshooting Microsoft SQL Server merge replication problems. The article provides guidelines and directions to determine the cause and resolution of some merge replication problems. However, this is not a... 894) 9/30/2007 Q328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access Denied" Error Message
"SQL Server does not exist or access denied" is a generic Microsoft Data Access Components (MDAC) message that indicates that the SQL Server cannot be contacted. This generic message has many potential causes. Some of the most common causes are... 895) 9/30/2007 Q232580 INF: Storing UTF-8 Data in SQL Server (Q232580)
Some applications (especially those that are Web based) must deal with Unicode data that is encoded with the UTF-8 encoding method. SQL Server 7.0 and SQL Server 2000 use a different Unicode encoding (UCS-2) and do not recognize UTF-8 as valid 896) 9/28/2007 Q321363 INF: SQL Server Memory Usage (Q321363)
When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory availa 897) 10/1/2007 Q321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition (Q321185)
This article describes how to identify your current SQL Server version number and corresponding product or service pack (SP) level. It also describes how to identify the specific edition if you are using SQL Server 7.0 or SQL Server 2000. 898) 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. 899) 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. 900) 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
1
2
.... .... 55
56
57
58
59
[ 60 ]
61
62
63
Previous Page
Page 60 of 63
Next Page
|