"Jim in Arizona" <tiltowait@hotmail.com> wrote in message
news:eLk0JF5KHHA.1248@TK2MSFTNGP02.phx.gbl...
> Hugo Kornelis wrote:
>> On Fri, 29 Dec 2006 13:35:09 -0700, Jim in Arizona wrote:
>>
>>> I'm running SQL2000 Standard on a 2003 standard server.
>>>
>>> I want to upgrade to 2005. I have about a half dozen small databases on
>>> the system with very basic table structure and maybe 20 very basic
>>> stored procedures (select and insert procedures).
>>>
>>> Anyone know of any problems of just throwing in the 2005 SQL Standard
>>> disk and choosing to upgrade? Is my nervousness warranted? :)
>>
>> Hi Jim,
>>
>> No known major problems. Your statistics will be hosed after the
>> upgrade, so run UPDATE STATISTICS after the upgrade or prepare for some
>> sub-optimal execution plans :-)
>>
>> Of course, you should run upgrade advisor first, then update a test
>> server and test all corners of your database before updating the live
>> production DB, but I assume that's a given.
>>
>
> Upgrade advisor huh? Never heard of that until now, so I'll dig a little
> deeper and look around for some info on it and give that a try.
>
> Thanks.

Hugo Kornelis wrote:
> On Fri, 29 Dec 2006 13:35:09 -0700, Jim in Arizona wrote:
>
>> I'm running SQL2000 Standard on a 2003 standard server.
>>
>> I want to upgrade to 2005. I have about a half dozen small databases on
>> the system with very basic table structure and maybe 20 very basic
>> stored procedures (select and insert procedures).
>>
>> Anyone know of any problems of just throwing in the 2005 SQL Standard
>> disk and choosing to upgrade? Is my nervousness warranted? :)
>
> Hi Jim,
>
> No known major problems. Your statistics will be hosed after the
> upgrade, so run UPDATE STATISTICS after the upgrade or prepare for some
> sub-optimal execution plans :-)
>
> Of course, you should run upgrade advisor first, then update a test
> server and test all corners of your database before updating the live
> production DB, but I assume that's a given.
>

Kalen Delaney wrote:
> Hi Jim
>
> Take a look at the SQL Server area on MSDN. There is a lot of interesting,
> useful information, including lots of downloads.
> Here is the download page:
> http://msdn2.microsoft.com/en-us/sql/aa336342.aspx
>
> The Upgrade Advisor is the 5th link down.
>

On Fri, 29 Dec 2006 13:35:09 -0700, Jim in Arizona wrote:

>I'm running SQL2000 Standard on a 2003 standard server.
>
>I want to upgrade to 2005. I have about a half dozen small databases on
>the system with very basic table structure and maybe 20 very basic
>stored procedures (select and insert procedures).
>
>Anyone know of any problems of just throwing in the 2005 SQL Standard
>disk and choosing to upgrade? Is my nervousness warranted? :)

On Fri, 29 Dec 2006 14:13:09 -0800, Kalen Delaney wrote:

>Hi Jim
>
>Take a look at the SQL Server area on MSDN. There is a lot of interesting,
>useful information, including lots of downloads.
>Here is the download page:
>http://msdn2.microsoft.com/en-us/sql/aa336342.aspx
>
>The Upgrade Advisor is the 5th link down.

"Hugo Kornelis" <hugo@perFact.REMOVETHIS.info.INVALID> wrote in message
news:oicbp2hfiqekdo5adl1jmjeai1l7j4tfbr@4ax.com...
> On Fri, 29 Dec 2006 14:13:09 -0800, Kalen Delaney wrote:
>
>>Hi Jim
>>
>>Take a look at the SQL Server area on MSDN. There is a lot of interesting,
>>useful information, including lots of downloads.
>>Here is the download page:
>>http://msdn2.microsoft.com/en-us/sql/aa336342.aspx
>>
>>The Upgrade Advisor is the 5th link down.
>
> Hi Kalen,
>
> Isn't the Upgrade Advisor included on the installation media? I seem to
> recall running it, and I can't recall downloading it. But then, at the
> current local time, I'm not sure how far I can trust my memory anymore!
>
> --
> Hugo Kornelis, SQL Server MVP