91) 6/18/2004 842422842422  842422.html">How to create a bar graph that has a trend line in a chart in Report Designer
(842422) - Describes how to plot data as a bar graph that has a trend line in Report Designer. Discusses two methods to plot data based on the complexity of the query that is used to retrieve the data.

92) 6/17/2004 843026843026  843026.html">BUG: You receive an error message when you try to deny access to a dimension member for a cube role by using a custom rule in Analysis Manager
(843026) - Discusses the "Dimension security syntax error" error message that you receive when you try to deny access to a dimension member for a cube role using a custom rule in Analysis Manager.

93) 6/17/2004 839980839980  839980.html">How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2
(839980) - This article contains two scripts that programmatically configure Windows Firewall to allow SQL Server to listen on the network on all ports or to listen only on TCP/IP.

94) 6/17/2004 811188811188  811188.html">FIX: The merge replication agent stops responding when you perform merge replication between a SQL Server database and a SQL Server CE database by using a custom conflict resolver
(811188) - This article discusses a hotfix for the problem of the merge replication agent not responding when you use a custom conflict resolver with merge replication and a conflict occurs between SQL Server 2000 and SQL Server CE.

95) 6/17/2004 318049318049  318049.html">FIX: The msmdarch command returns an exit code of 0 in SQL Server OLAP Services 7.0
(318049) - This article discusses why the msmdarch command may return an incorrect exit code.

96) 6/16/2004 238822238822  238822.html">INF: How to Rebuild the Repository in SQL Server 7.0
(238822) - This article describes the steps you need to perform to rebuild the SQL Server 7.0 repository, should it become necessary to do so.

97) 6/16/2004 841627841627  841627.html">FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstances
(841627) - Describes a problem that may occur when you run a query that is based on a view, and the query is slow and inconsistent. Includes a hotfix that you can use to resolve the problem.

98) 6/16/2004 117559117559  117559.html">INFO: How to Correlate Spid, Kpid, and Thread Instance
(117559) - When you debug certain types of problems, it is periodically necessary to correlate a particular spid number with its corresponding kpid and/or thread instance number. This article explains how to do this.

99) 6/16/2004 178295178295  178295.html">How to Obtain SQL Server 6.5 Service Pack 4
(178295) - This article describes how to obtain Service Pack 4 for Microsoft SQL Server version 6.5. To see a complete list of bugs that are fixed by this update, see the Fixlist.txt file that accompanies the Service Pack. NOTE : This Service Pack is for use...

100) 6/16/2004 272180272180  272180.html">SAMPLE: How to Retrieve XML Data Using a Template File with ADO in Visual C++
(272180) - XMLTemplate.exe demonstrates how to extract an XML stream from a SQL Server 2000 database using an XML Template file and the ADO Command object.

101) 6/14/2004 180500180500  180500.html">PRB: Missing device causes database to be marked suspect
(180500) - SQL Server marks a database suspect if any of the device files for the database are unavailable when it attempts to start. You may see either of the following sets of messages in the SQL Server error log: 96/11/18 10:48:32.60 kernel udopen: Operating...

102) 6/12/2004 831999831999  831999.html">FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000
(831999) - Describes a fix for a problem with an AWE-enabled SQL Server using too much memory for queries that contain sort or hash operators. Under some circumstances, this may cause a BPool::Map error to be written to the SQL Server error log.

103) 6/12/2004 841856841856  841856.html">FIX: A memory leak occurs when you run queries in the same connection in Analysis Services
(841856) - Describes a problem that occurs when the memory usage of the client process that uses the Pivot Table Services client increases. Includes a hotfix that you can apply to resolve this problem.

104) 6/11/2004 838460838460  838460.html">FIX: The xp_logininfo procedure may fail with error 8198 after you install Q825042 or any hotfix with SQL Server 8.00.0840 or later
(838460) - Fixes a problem in SQL Server 2000 where the xp_logininfo extended stored procedure may fail when you install Q825042.

105) 6/10/2004 280102280102  280102.html">How to set up a linked server to a Sybase database server and troubleshoot problems that may occur
(280102) - This step-by-step article describes how to set up a linked server to a Sybase database server on a computer that is running Microsoft SQL Server. Additionally, this article contains basic troubleshooting steps for problems that may occur when you set...