Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Browse by Tags

All Tags » sp2   (RSS)
Cumulative Update 9 for SQL Server 2005 Service Pack 2 - another update package in line
In continuation to the CumulativeUpdate package posts here for SQL Server 2005 SP2 we have another set of cumulative update package no.9 ready for testing. TO obtain this read the notes from Microsoft: .... Apply it only to systems that are experiencing Read More...
End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?
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 Read More...
How to get a list of SQL Server 2005 builds that were released after Service Pack 2 was released?
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/10/16/keep-your-eyes-open-for-cumulative-update-4-for-sql-server-2005-service-pack-2.aspx Read More...
SQL Server Errors: could not spawn FRunCM thread and TDSSNIClient initialization failed with error 0xd, status code 0x36.
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 Read More...
How many languages are supported within Full Text Search in SQL 2005?
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 Read More...
Cumulative Update 3 for SQL Server 2005 Service Pack 2 - watch this space
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 Read More...
Reducing Database Size by Using Vardecimal Storage Format
Useful information on data storage format using available data-types in SQL Server 2005 SP2: The Vardecimal storage format became available starting with Microsoft SQL Server 2005 Service Pack 2 (SP2) in the Enterprise Edition. This storage format can Read More...
SQL Server 2005 Service pack 2 re-release & too many builds
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 Read More...
How do I remove Service pack 2 for SQL Server 2005?
In the README.HTML for SQL Server 2005 Service Pack 2 there are install instructions that covers the uninstall procedures too: > 1.3 Uninstalling SQL Server 2005 SP2, Once SQL Server 2005 SP2 has been applied, it cannot be removed without uninstalling Read More...
SQL Server 2005 Service Pack 2a?
With the latest release of SP2 Update release it has been a rumour in the community that it is a SP2a release, which I believe not as it is intended to fix a particular issue with cleanup tasks and maintenance plans. As the remaining tasks with Service Read More...