SqlServer-QA.net

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 is not easy decision for User Community to apply with CU than going Service Pack release which ...

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 practice of checking of whether its a security issue to allow the logins, if so then goto ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New and Major Modifications How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008http://support.microsoft.com/kb/945934/en-US

The following pages were recently modified. Source: Knowledge BaseProduct: Analysis Cubes for Microsoft SQL Server 2005Notification Contents: New and All Modifications How to install Analysis Cubes for Microsoft Dynamics GPhttp://support.microsoft.com/kb/945953/en-US

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 similar behaviour within their Management Studio (SSMS) screens (using desktop) when trying ...

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 for all service pack updates aka they call it now as a software update packages for ...

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 changes yes, you can change the name of an instance as long as the server is not ...

The following pages were recently modified. Source: Knowledge BaseProduct: Analysis Cubes for Microsoft SQL Server 2005Notification Contents: New and All Modifications The compatibility between Analysis Cubes for Microsoft SQL Server 2005 in Microsoft Dynamics GP 9.0 and 64-bit operating systemshttp://support.microsoft.com/kb/929156/en-US

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New and Major Modifications FIX: Event ID: 1 may be logged when you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in SQL Server 2005http://support.microsoft.com/kb/934396/en-US

Have you ever wondered what could be the Disaster Recovery (DR) options available for SQL Server. In the documentation terms: Disaster recovery is a process that you can use to help recover information systems and data, if a disaster occurs. Some examples of disasters include a natural or a man-made disaster such as a fire, or a technical ...