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 » service pack   (RSS)
Support for SQL Server 2005 SP2 and SQL Server 2008 RTM ends soon!
Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions! It is quite common scenario that few of Enterprises may not have gone to Read More...
SQL Server version has a known compatibility issues with Windows 7 RC. This warning is genuine and applies to all SQL Server editions, including all Express editions.
There is no need to guess about the rootcause of the above error message, as it clearly mentions about compatibility issues as a warning! The above error was presented to me recently when I'm trying to install SQL Server 2005 & 2008 versions on my Read More...
Production version of SQL Server 2005 Service Pack 3 (SP3) is released
From the Are you ready for SP3 and SQL2005SP3_WorkStarted posts here, it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to test and apply on your SQL Server 2005 instances. The Official SQL Server News Read More...
SQL Server Release Services - Cumulative Update or frequent Service pack releases, which one you favour?
Here is the hot news, SQL Server Global Release Services (GRS) has revised their schedule of releasing Service Packs for SQL Server product by stating ' changed approach to Service Packs '. Now the big question how far you can stretch in deploying these Read More...
Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)
Here is another candidate of 7 within Cumulative Update service for SQL Server 2005 SP2. SQL Server Release Services team has announced (yesterday) that another instalment of Cumulative Update ( series here ) for SQL Server 2005 on Service Pack 2, it 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...
Msg: 2522 The index "<name>" (partition 1) on table "TableName" cannot be reorganized because page level locking is disabled.
All of sudden the re-org of an index started failing and no error was displayed within that scheduled job we execute. After executing the code from Query Editior I was able to get the message as follows: Msg 2552, Level 16, State 1, Line 3 The index "<name>" Read More...
Set a stage for smooth upgrades of your SQL Server environment
Well the prime criteria for DBAs is to upgrade from the previous versions to latest version and it is not an easy option or platform to perform so quickly without having a proper testing within their environment. As far as the SQL Server is concerned 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...