Browse by Tags
All Tags »
kba (RSS)
We have been struggling to uninstall the Cumulative Update package 7 on a development SQL Server! As it is an important aspect of installation to rollback or to have a backout plan tested if you are performing any kind of installation against your Production
Read More...
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...
Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual
Read More...
In addition to the blog post SSMS-waiting-for-an-internal-operation-to-complete I have faced additional problems such as all the menus aren't displayed within SQL Server Management Studio from the same laptop. Other users within our team has observed
Read More...
Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema
Read More...
August 19 2007: As per the KBA-BlogPost on Cumulative Update 4 for SQL 2005 SP2, Microsoft confirms that this cumulative update package will be released in the October 2007 timeframe. The information that is presented here is subject to change at any
Read More...
MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete this transaction with a subsequent
Read More...
Another common question on the forums, may be not a frequently performed task and as a DBA you should discourage in performing such actions. Microsoft SQL development team has already documented the information over the KBA 303774 and for the server name
Read More...
On one of the archive database (using SQL 2005) we have a monthly task to shrink the transaction log during every 1st week of the month, this is required due to clear up the space on one of the drives where the additional transaction log file located
Read More...
Recently SQL Server support team had changed the process of releasing support hotfixes for the issues that are specific to a customer base. This KBA revises the incremental servicing model that is deployed for all the support fixes. We have moved away
Read More...
Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server
Read More...
Scenario is like this: Error generated when trying to register the Linked server between 2 SQL instances. SQL Server setup information is as follows: provider:SQL native Client Product Name: SQLNCL1 Data Source: Somewhere IN this world (SQLServer 2000
Read More...
In SQL Server 2000 for index defragmentation DBCC DBREINDEX and DBCC INDEXDEFRAG statements are used, as you are aware defragmentation on table does not yield performance gains in every case. Every scenario is different. Similarly, determining when you
Read More...
To know more about refer to this KBA that is applicable for SQL Server 2005 Enterprise Edition on X64 & Itanium based systems.
Read More...