Browse by Tags

All Tags » upgrade (RSS)
SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Published 13 February 8 5:2 AM | SSQA.net
One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout...
Filed under: , , , , , , ,
You encounter a problem with a subscription that uses the file share delivery extension in SQL Server 2005 Reporting Services or in SQL Server 2008 Reporting Services after you upgrade Windows Server 2003 to Windows Server 2008
Published 30 January 8 9:31 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete You encounter a problem with a subscription that uses the file share delivery...
Filed under: , , , , , ,
SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb
Published 22 January 8 7:55 AM | SSQA.net
Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgrageTags posts. Here in this post I would like to go with few FAQs that...
Filed under: , , , , , , , , , ,
All about SQL Server with 32bit to 64bit cluster migration - steps to take care
Published 15 January 8 2:44 AM | SSQA.net
An interesting cross-post from SSP Blog - read thisblog for more information....( read more ) Read More...
Filed under: , , , , , , , ,
Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?
Published 16 November 7 4:53 AM | SSQA.net
I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...
Filed under: , , , , , , , , , , , , ,
SQL Server Virtual Labs - fully featured virtual environment for testing!
Published 5 October 7 11:4 AM | SSQA.net
Virtual labs - in simple words its simple to use where a pre-installed environment is setup to try out /test SQL Server installation for your databses upgrade, that has full-featured labs. Not only this you have an option to download manual with a 90...
Filed under: , , , , , , , ,
Error: Database diagram support objects cannot be installed because this database does not have a valid owner
Published 6 September 7 4:0 AM | SSQA.net
If you have been using the database diagrams from SQL Server 2000 onwards and when it is upgraded to SQL 2005 you might get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects...
Filed under: , , , , , , ,
Problem with migrating database from a SQL Server Evaluation edition to a purchased version
Published 31 August 7 5:25 AM | SSQA.net
During a user group meeting one of the user asked that If we were to migrate our databases over to the evaluation edition of SQL Server 2005, is there a way of upgrading to the purchased (licensed) version (before the 180 day expires) without uninstalling...
Filed under: , , , , , , ,
Setting database compatibility to SQL 2000 on a SQL Server 2005 instance?
Published 30 August 7 5:2 AM | SSQA.net
No doubt that as compare to previous version the current SQL Server 2005 provides more new language constructs and primitives for the T-SQL language than can be utilized. Still there are many out there not entirely ready to upgrade from SQL Server 2000...
Filed under: , , , , , , , ,
FIX: Error message when you run a stored procedure that references tables after you upgrade a database from SQL Server 2000 to SQL Server 2005: "A time-out occurred while waiting for buffer latch"
Published 19 August 7 4:44 PM | SSQA.net
Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you run a stored procedure...
Filed under: , , , ,
Downgrade or revert or restore SQL Server 2005 database to SQL Server 2000 version
Published 20 July 7 3:21 AM | SSQA.net
Can somebody tell me, it is possible to convert a database developed in sql2005 back to sql2000? A common question now a days in the forums and newsgroups, as you are aware UPGRADE process is available to enhance SQL 2000 database to SQL 2005 as per the...
Filed under: , , , , , ,
Understanding the latest SQL Server TPC H scores
Published 19 June 7 12:30 PM | SSQA.net
Cross post from AskASQLGuru site....( read more ) Read More...
Filed under: , , ,
So what's the stand on supporting SQL Server on Vista & Windows 2008
Published 5 June 7 10:7 AM | SSQA.net
I believe day by day the support options are changing on Vista and with recent evolution of Windows Server 2008, Microsoft has been investing and preparing a lot of trustworthy secured computing methods in all their products. So whats the catch on the...
Filed under: ,
Hush hush about next release of SQL Server
Published 10 May 7 5:16 AM | SqlServer-QA.net (SSQA)
When I have attended the MVP global summit there was much talk and sessions on SQL Server next release 'Katmai', well I cannot talk much here due to the NDA. I'm surprised to see first (may be) press release on the upcoming features information...
Filed under: , , , , ,