Welcome to SSQA.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 » upgrade   (RSS)
SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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 Read More...
SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb
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 UpgradeTags posts. Here in this post I would like to go with few FAQs that Read More...
All about SQL Server with 32bit to 64bit cluster migration - steps to take care
An interesting cross-post from SSP Blog - read thisblog for more information. Read More...
Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?
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 Read More...
SQL Server Virtual Labs - fully featured virtual environment for testing!
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 Read More...
Error: Database diagram support objects cannot be installed because this database does not have a valid owner
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 Read More...
Problem with migrating database from a SQL Server Evaluation edition to a purchased version
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 Read More...
Setting database compatibility to SQL 2000 on a SQL Server 2005 instance?
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 Read More...
Downgrade or revert or restore SQL Server 2005 database to SQL Server 2000 version
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 Read More...
So what's the stand on supporting SQL Server on Vista & Windows 2008
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 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...
Easy way to upgrade from previous version
Redirect link . Read More...
Easy way to upgrade from previous version of SQL Server
http://sqlserver-qa.net/blogs/bc/archive/2007/03/17/what-is-your-way-easy-to-upgrade-from-previous-versions.aspx Read More...