1156) 9/26/2007 Q111401 INF: Iterating Through a Results Set Using Transact-SQL (Q111401)
It is often desirable to simulate a cursor-like FETCH-NEXT logic in a stored procedure, trigger, or Transact-SQL batch. This article will discuss various methods for accomplishing this task. 1157) 9/19/2007 Q230785 INF: SQL Server 7.0 and SQL Server 2000 Logging and Data Storage Algorithms Extend Data Reliability (Q230785)
SQL Server 7.0 and SQL Server 2000 restructure and redesign the logging and data algorithms from earlier Microsoft SQL Server releases to improve data reliability and integrity. 1158) 9/23/2007 Q200473 ACC2000: Explanation of the New Group Properties in the Sorting and Grouping Dialog Box of a Data Access Page (Q200473)
Although data access pages and reports have many grouping and sorting properties in common, there are some new properties that have been added to the Sorting and Grouping dialog box for data access pages. These new properties change the behavior 1159) 9/30/2007 Q200206 ACC2000: Page Remains in DB Window After Deleting HTML File (Q200206)
If you delete the associated HTML file for a data access page, the Database window does not refresh when you open the database or press the Database window refresh key (F5). When you try to open a page, and if someone has deleted the underlying 1160) 9/29/2007 Q200047 Error Uninstalling Internet Explorer on Terminal Server (Q200047)
When you try to uninstall Internet Explorer on a computer running Windows NT Server, Terminal Server edition through the Add/Remove Programs utility in Control Panel, you may receive the following error message: Setup has determined 1161) 9/30/2007 Q315512 INF: Considerations for Autogrow and Autoshrink Configuration (Q315512)
The default 1162) 10/1/2007 Q313702 PRB: SQL Server Service May Fail to Start with I/O Error Message 38 in tempdb (Q313702)
The SQL Server service may fail to start and you may receive the following error messages in the SQL Server error logs or in the event viewer application log of the computer: spid5 Clearing tempdb database. spid5 Encountered an 1163) 9/30/2007 Q310834 PRB: Common Causes of Error Message 844 or Error Message 845 (Buffer Latch Time Out Errors) (Q310834)
A computer may stop responding (hang), or a time out or some other disruption of normal operations may occur at the same time that SQL Server writes buffer latch errors to the SQL Server error log. The error messages that occur as a result of a 1164) 9/30/2007 Q319578 PRB: SQL Server 2000 Cluster May Not Bind to Port If SQL Server IP Address Is Changed (Q319578)
Attempts to bring a SQL Server 2000 virtual instance online on a cluster may fail, or the SQL Server 2000 virtual instance on the cluster may come online successfully, but the SQL Server 2000 virtual instance on the cluster will only listen 1165) 10/1/2007 Q314530 PRB: Error Message 7399: "Timeout Expired" Occurs with Linked Server Query (Q314530)
You may see either one of the following error messages when you execute a linked server query: 1166) 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 1167) 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 1168) 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 1169) 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 1170) 9/28/2007 Q262973 PRB: Possible Thread Starvation Detected Message Reported in the SQL Server Error Log (Q262973)
Starting with SQL Server 7.0 Service Pack 2 (SP2), SQL Server adds a new warning message expressing the wait state of worker threads on the assigned UMS scheduler. When all worker threads for a given UMS scheduler are in a wait state, it is possible
1
2
.... .... 72
73
74
75
76
77
[ 78 ]
79
80
Previous Page
Page 78 of 80
Next Page
|