Welcome to

SqlServer-QA.net

Sign in | Join | Help

SQL Server Knowledge Base articles (SSQA.net)

Microsoft support engineers regularly document the solutions to problems that customers call in with, they are Knowledge Base articles or we call them as KBA.

May 2008 - Posts

Changes to a SQL Server Agent job are lost when the job corresponds to a subplan in a maintenance plan that you created in SQL Server 2005 Service Pack 2
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64Edition Notification Contents: New Changes to a SQL Server Agent Read More...
Posted: Thursday, May 29, 2008 11:29 AM by SQL Master | 2 Comments
Filed under: , , , ,
A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete A call to the AuthzInitializeContextFromSid API function fails during the Read More...
Posted: Tuesday, May 20, 2008 12:54 AM by SQL Master | 2 Comments
Filed under: , , , , , ,
FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: An ongoing MS DTC transaction is Read More...
Posted: Thursday, May 15, 2008 1:14 AM by SQL Master | 2 Comments
Filed under: , , , , ,
A System.InvalidOperationException exception may occur when you try to use a Visual Studio .NET 2003 client application against a SQL Server 2005 native Web service
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications A System.InvalidOperationException exception may occur when you try to use a Visual Read More...
Posted: Wednesday, May 14, 2008 11:09 PM by SQL Master | 2 Comments
Filed under: , , , , ,
KBA - UPDATE Statements May be Replicated as DELETE/INSERT Pairs & Diagnostics in SQL Server 2000 SP4 and in later versions help detect stalled and stuck I/O operations
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications UPDATE Statements May be Replicated as DELETE/INSERT Read More...
Posted: Tuesday, May 13, 2008 11:45 AM by SQL Master | 2 Comments
Filed under: , , , , , , ,
A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications A query that references a nondeterministic Read More...
Posted: Monday, May 12, 2008 11:43 AM by SQL Master | 2 Comments
Filed under: , , , , , ,
New and Modified Knowledge Base article for SQL Server 2005 Reporting Services
Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server Read More...
Posted: Thursday, May 08, 2008 1:31 PM by SQL Master | 2 Comments
Filed under: , , , , , , , , , , ,
FIX: Error message when you use the BULK INSERT statement to import data of the timestamp data type in SQL Server 2005: "An invalid datetime value was encountered"
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you use the BULK Read More...
Posted: Wednesday, May 07, 2008 1:28 PM by SQL Master | 2 Comments
Filed under: , , , , ,
The identity column of the destination table does not contain the same identity values as the source table after you use SQL Server Management Studio to import data or to export data in Microsoft SQL Server 2005
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications Read More...
Posted: Tuesday, May 06, 2008 8:07 AM by SQL Master | 1 Comments
Filed under: , , , , , ,
Recommendations for using SQL Server 2005 as the metadirectory data store for MIIS 2003 SP2 and for ILM 2007
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications Recommendations for using SQL Server 2005 as the metadirectory data store for Read More...
Posted: Monday, May 05, 2008 1:39 AM by SQL Master | 2 Comments
Filed under: , , , , , , ,