SqlServer-QA.net

I taught a private class last week near Portland (Oregon) and although the company has a lot of SQL Servers, there was not much excitement at all about SQL Server 2008. They still have many SQL Server 2000 installations, and are debating whether to upgrade those to 2005. Most of the interest was in the real value of the new 2005 features, like ...

I taught a private class last week near Portland (Oregon) and although the company has a lot of SQL Servers, there was not much excitement at all about SQL Server 2008. They still have many SQL Server 2000 installations, and are debating whether to upgrade those to 2005. Most of the interest was in the real value of the new 2005 features, like ...

I am using ssma to migrate db from oracle 9i to sql server 2000. I successfully migrated oracle tables,views,procedures,functions etc.. But can you please help me on how to migrate packages,triggers and indexes? Here i can able to view the headings like''Triggers'', ''packages'', ''Indexes'' in SSMA. But none of my oracle objects are displaying ...

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 0, also further ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification 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 or in SQL Server 2008 Reporting ...

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 are related to Upgrade process & procedure: Say you need to ...

Fais Your list of steps are simple and clear to follow and I hope you have tested them already. If not for a simulation make sure to go through on a virtual server (non0clustered) to give you more in hand experience. This is required to get a feel of how you are going to manage the upgarde tasks, as it may not be as easy it said, and I would like ...

An interesting cross-post from SSP Blog - read thisblog for more information.

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 2005 offers a number of ...

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. All you have to do is sign-up (free) on ...