16) 5/20/2012 270671 PRB: Full Text Search Menus Are Not Enabled for Local Windows NT Accounts
You cannot administer Full Text Search (FTS) from SQL Server Enterprise Manager (SEM) from a client computer when you are using a local user account to log on to the computer. This behavior occurs even if you connect to SQL Server with the "sa"... 17) 5/18/2012 230036 BUG: Heavy Full Text Query Activity Results in Unexpected Timeout Errors
Heavy Full Text Search activity from SQL Server against a single catalog can result in timeout errors or slower than normal full text query completion. The following error may occur: Server: Msg 7619, Level 16, State 1, Line 3 The query timed out.... 18) 5/15/2012 234521 BUG: Inserting Data into Temporary Table's Identity Column in Stored Procedure Fails
If you run a stored procedure that inserts data into a temporary table that contains an identity column, the second and all subsequent executions of the procedure fail with the following error: Server: Msg 544, Level 16, State 1 Cannot insert... 19) 5/16/2012 250506 FIX: Concurrent Execution of Stored Procedure That Recompiles May Fail To Execute All Statements
A stored procedure may silently fail to execute all statements contained within it if the following conditions are met: Multiple connections are executing the same procedure concurrently.A reference is made to a temporary table created outside of... 20) 5/23/2012 814578 PRB: OLE Automation Error Occurs When SQL Server Runs a Stored Procedure
When you run a stored procedure in Microsoft SQL Server 7.0, the execution might fail, and you receive an error message similar to the following: -2147467259OLE Automation Error(s) InformationHRRESULT: 0xSource : ProviderDescription : Unspecified... 21) 5/25/2012 301299 PRB: Security Context of Dynamic SQL Statements Inside a Stored Procedure
When you are running a stored procedure with a dynamic execution query ( sp_executesql or EXECUTE), you may receive the following error message: Server: Msg 229, Level 14, State 5, Line 1 'permission' permission denied on object 'object', database... 22) 12/3/2005 44519& INF: Error Handling in Transact-SQL Blocks and Stored Procedures
This article describes how Microsoft SQL Server handles errors in Transact-SQL blocks and stored procedures. The article also explains error handling in nested Transact-SQL and nested stored procedures. Here is the list of errors that occur in... 23) 5/24/2012 275721 FIX: Execution of Stored Procedure with Local Temp Table and Indexes May Fail or Return Incorrect Results
The execution of a stored procedure that has a local temp table with indexes may return incorrect results or may sometimes fail with the following error message: Server: Msg 602, Level 21, State 13, Procedure test, Line 9 Could not find row in... 24) 5/19/2012 309182 PRB: Slow DELETE or UPDATE Against Non-SQL Linked Server
UPDATE or DELETE statements that act against a remote table that resides on a non-SQL Server data source, may run much slower than an equivalent SELECT statement. For linked server DELETEs or UPDATEs, SQL Server retrieves data from the table,... 25) 5/23/2012 276447 BUG: Access Violation Occurs When a Variable is Used in FREETEXTTABLE Function as Search String Inside a Cursor Definition
An Access Violation (AV) may occur when you execute a stored procedure that defines a dynamic or static cursor, and both of the following conditions are met: The cursor uses the FREETEXTTABLE function in its SELECT statement. -and-A variable that... 26) 5/19/2012 260388 PRB: SQL Server 7.0 Setup Fails at Configuration Phase Because of Insufficient Permissions
SQL Server 7.0 Setup may fail during the configuration phase if there are insufficient permissions established. If the drive or the partition to which you are installing SQL Server 7.0 does not have the SYSTEM account with full control permission,... 27) 5/21/2012 295026 PRB: Errors When You Redistribute SQL Server 2000 DMO Clients in SQL Server 7.0 Environment
After you successfully register the SQL Server 2000 Distributed Management Objects (SQL-DMO) DLLs in an environment with the SQL Server 7.0 Client tools installed, when you start SQL Server 7.0 Enterprise Manager (SEM), you may receive the... 28) 5/19/2012 255633 FIX: SET ROWCOUNT or TOP With Partitioned View May Cause Poor Performance
If you use the SET ROWCOUNT option or TOP keyword to limit results, a SELECT on partitioned views takes longer because it introduces extra SPOOL in the query execution plan. This only happens if the view is defined on a large number of tables in... 29) 5/9/2012 197562 BUG: Heterogeneous Query Showplan May Not Display Site Name
When executing a heterogeneous query, the Showplan output does not always display the site name where that portion of the query plan was executed. To work around this problem, refer to the query and determine the site by determining which site... 30) 5/11/2012 234883 FIX: Wrong Index Chosen When Query References Values Beyond Statistics
The optimizer may select the wrong plan for processing a query if the values in a search argument are not contained within the range of statistics for an expected index. This can cause significantly slower performance in queries. This situation is...
1
[ 2 ]
3
4
5
6
7
8
.... .... 209
210
Previous Page
Page 2 of 210
Next Page
|