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