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 setting which has been left with default value...
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 extension in SQL Server 2005 Reporting Services...
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 are related to Upgrade process & procedure...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-22-2008
Filed under: sql server, database, upgrade, best practices, sa, clustering, database mail, data files, FAQ, gotchas, sqlmail
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 the reasons). But one thing is sure that SQL Server...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
11-16-2007
Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins
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-minute block for each module if you are not sure enough...
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 cannot be installed because this database does...
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 or stopping the converted migrated running or...
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 to 2005. In this case you can take few advantages...
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 that references tables after you upgrade a database...
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 documented process in BOL. How about downgrade...