Browse by Tags

Recommendations for using SQL Server 2005 as the metadirectory data store for MIIS 2003 SP2 and for ILM 2007

Published 5 May 8 3:39 AM | SSQA.net

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...

Filed under: sql server, sp2, kba, directory, miis, ilm, notification services, meta

End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?

Published 8 April 8 2:2 AM | SSQA.net

The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement...

Filed under: sql server, sp2, support, lifecycle, 2000, 2005, service pack, css, case, mainstream, extended

How to get a list of SQL Server 2005 builds that were released after Service Pack 2 was released?

Published 23 November 7 8:51 AM | SSQA.net

Since the release of SQL Server 2005 Service Pack 2, Microsoft development team has released various builds that are classed as Cumulative Updates. Also we blogged on this site - CumulativeUpdate4 & http://sqlserver-qa.net/blogs/tools/archive/2007...

Filed under: sql server, package, microsoft, update, sp2, best practices, hotfix, service pack2, testing, cumulative

FIX: The status of the shared schedule appears as Paused after you click Resume when you use Report Manager in SQL Server 2005 Reporting Services SP2

Published 8 October 7 2:48 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The status of the shared schedule appears as Paused after you click...

Filed under: sql server, sp2, report builder, kba, sa, reporting services, report manager, schedule

SQL Server Errors: could not spawn FRunCM thread and TDSSNIClient initialization failed with error 0xd, status code 0x36.

Published 25 September 7 4:53 AM | SSQA.net

On one of the SQL Server instance recently we have been getting the following error: SQL Server could not spawn FRunCM thread. Error: 17182, Severity: 16, State: 1. 2005-10-30 15:35:44.79 Server TDSSNIClient initialization failed with error 0xd, status...

Filed under: sql server, sp2, error, error log, client, VIA, FRUNCM, TDS, protocols

How many languages are supported within Full Text Search in SQL 2005?

Published 22 August 7 3:51 AM | SSQA.net

During the deployment of new project for an application that is accessed worldwide by one of my client. Ther were looking to implement Full Text Search as well due to the nature of application. For your information SQL-FTS: SQL Server Full Text Search...

Filed under: sql server, search, sp2, support, 2005, full, text, language

FIX: Error message when you run a query that fires an INSTEAD OF trigger in SQL Server 2005 Service Pack 2: "Internal Query Processor Error The query processor could not produce a query plan"

Published 20 August 7 5:18 PM | SSQA.net

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 FIX: Error message when you run a query that...

Filed under: sql server, query, sp2, kba, trigger, processor

FIX: The event information that is generated by a child package does not have a "User:" prefix in Integration Services in SQL Server 2005 Service Pack 2

Published 15 August 7 4:7 PM | SSQA.net

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 FIX: The event information that is generated...

Filed under: sql server, ssis, sp2, kba, child package

Cumulative Update 3 for SQL Server 2005 Service Pack 2 - watch this space

Published 10 August 7 8:8 AM | SSQA.net

Yet another information on cumulative update for SQL Server 2005 Service Pack 2 installations and make are note of the following: This cumulative update package will be released in August 2007. The information that is presented here is subject to change...

Filed under: sql server, package, update, sp2, 2005, cumulative

Enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function

Published 16 July 7 3:53 AM | SSQA.net

You may be aware OBJECT_NAME function can be use to return the database object name, I think since SQL 2000 when system functions are used the parameter of a system function is optional, the current database, host computer, server user, or database user...

Filed under: sql server, sp2, tsql, object_name, enhancement, schema

KBA:The service pack update or hotfix installation stops unexpectedly when you try to install either Microsoft SQL Server 2005 Service Pack 2 or a hotfix for SQL Server 2005 SP2

Published 10 July 7 4:48 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64Edition Notification Contents: New and Major Modifications The service pack update or hotfix installation...

Filed under: sql server, sp2, kba, hotfix, installation

Modified: A clean-up task does not delete database maintenance plan reports after you install SQL Server 2005 Service Pack 2

Published 8 June 7 2:24 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications A clean-up task does not delete database maintenance plan reports after you install SQL Server 2005 Service Pack 2 http://support...

Filed under: sql server, database, sp2, kba, maintenance

SQL Server 2005 Service pack 2 re-release & too many builds

Published 15 May 7 3:17 AM | SqlServer-QA.net (SSQA)

I feel like there is lot of confusion ( new users ) in deciding which build to apply after the re-release of SQL Server 2005 Service Pack2 during the month of March 2007. So here is the list of references I would like to share in explaining what is what...

Filed under: sql server, security, server, search, replication, sp2, i/o