46) 7/9/2004 823429823429  823429.html">FIX: You receive error message 7410 when you use a distributed query as a query parameter for the xp_sendmail stored procedure or the sp_makewebtask stored procedure in SQL Server 2000
(823429) - This article discusses that running a distributed query as a part of the xp_sendmail stored procedure or the sp_makewebtask stored procedure may cause error 7410. To resolve the problem, install the hotfix that is mentioned in the article.

47) 7/9/2004 837816837816  837816.html">FIX: You receive an error when you try to update the fields in the dataset of a report in Report Designer
(837816) - Fixes the problem in Report Designer that occurs when you try to refresh the fields in a dataset that uses the Oracle data extension to call an Oracle stored procedure. Requires that you install Reporting SP 1 to resolve the problem.

48) 7/3/2004 257868257868  257868.html">How To Get the PackageID for Use in the LoadFromRepository Function
(257868) - In order to load a specific DTS package that is stored in the repository you must use the LoadFromRepository function. One of the function's required parameters is the PackageID. This ID identifies the DTS Package uniquely in the repository. The code...

49) 7/3/2004 264005264005  264005.html">FIX: Error Message 8623 Occurs If You Use INSERT-SELECT with NOT IN or NOT EXISTS Keywords in Subquery of the WHERE Clause
(264005) - An attempt to INSERT INTO a column that uses a declared variable may fail if the column has the same data type as the declared variable and the WHERE clause contains a subquery that uses either a NOT EXISTS or a NOT IN keyword. In such cases, the...

50) 7/3/2004 246702246702  246702.html">FIX: Regression: Specific Inner Join Slower with Service Pack 1 Applied
(246702) - A specific query involving an inner join with multiple search clauses and a HAVING clause has been found to run slower on SQL Server 7.0 after Service Pack 1 was installed.

51) 7/3/2004 238399238399  238399.html">How To Allow an English Query to Interact with Non-SQL7 Data
(238399) - This article describes how to use a Microsoft SQL Server 7.0 heterogeneous query to allow an English Query (EQ) to generate queries for other data sources besides Microsoft SQL 6.5 and Microsoft SQL Server 7.0. By following these steps, you can use EQ...

52) 7/1/2004 291235291235  291235.html">FIX: Query Analyzer Hangs After You Drag & Drop Files Into the Query Editor and You Close One of the Newly Created Windows
(291235) - If you drag and drop more than 50 files at one time into the Editor pane of the Query Analyzer, a new query editor opens for each of the files. If you then attempt to close one of the windows by clicking the Close button of the query window, Query...

53) 7/1/2004 258198258198  258198.html">FIX: Error Message 8630 Occurs When Updates are Performed to a Table with Compound Keys
(258198) - A table with compound keys, which has a Primary key constraint with a nonclustered index and foreign key constraints, returns an 8630 error message during an update: Server: Msg 8630, Level 17, State 38 Internal Query Processor Error: The query...

54) 7/1/2004 250550250550  250550.html">How To Change SQL Server Default Network Library Without Using Client Network Utility
(250550) - You may sometimes want to change the default network library a client computer uses to communicate with SQL Server. The usual procedure to do this is to use the Client Network Utility to change this setting. However, in some instances, you cannot...

55) 7/1/2004 246498246498  246498.html">FIX: SP1 Query Analyzer Reports an Illegal Operation and Exits on Windows 9x
(246498) - When you use the version of Query Analyzer that ships with Service Pack 1 on a Windows 95 or Windows 98 computer, Query Analyzer might exit with the following dialog box after attempting to perform queries that contain aggregate functions in the...

56) 7/1/2004 196652196652  196652.html">HOWTO: Implement Custom Rounding Procedures
(196652) - There are a number of different rounding algorithms available in Microsoft products. Rounding algorithms range from Arithmetic Rounding in Excel's Worksheet Round() function to Banker's Rounding in the CInt(), CLng(), and Round() functions in Visual...

57) 7/1/2004 100365100365  100365.html">INF: DIFFERENCE() and SOUNDEX() Functions in Transact-SQL
(100365) - The DIFFERENCE () and SOUNDEX () functions in Transact-SQL allow searches on character strings that "sound similar." SOUNDEX () converts each string into a 4-digit code. DIFFERENCE () can then be used to evaluate the level of similarity between the...

58) 6/30/2004 306039306039  306039.html">PRB: Long Running OLAP Queries do not Return Data When Connected Through HTTP
(306039) - When you run a long running MDX query against an Analysis Services server through an HTTP or HTTPS connection, the client may never receive the results of the query. However, if you run the same query from a standard TCP/IP connection to the server,...

59) 6/30/2004 295732295732  295732.html">INF: Creating Databases or Changing Disk File Locations on a Shared Cluster Drive on Which SQL Server 2000 was not Originally Installed
(295732) - After you install a SQL Server 2000 virtual server instance, you may want to create databases, or move existing data or log files onto a secondary shared cluster disk. To create databases, or move existing data or log files, the other disk that SQL...

60) 6/30/2004 300183300183  300183.html">FIX: SQL Server Cluster Resource Fails to Come Online Until Cluster Service Is Restarted
(300183) - If the SQL Server cluster resource is in an "online pending" state and the cluster service sends a termination request to the resource, the resource may not successfully come online again on the node until the cluster service is restarted. The cluster...