We're going to be upgrading our in place SQL 2000 server to 2005 and I was
wondering if anyone could post up any gotchas or things to look out for?
Thanks!!

Download the 2005 Upgrade Advisor and run it against your SQL 2000 server to
report on issues you will face. And read the associated document, too.
http://www.microsoft.com/downloads/d...displaylang=en

We found it very ful and covered pretty much everything that we needed
to deal with.

RLF

"OverSeer" <OverSeer@discussions.microsoft.com> wrote in message
news:EEF638EC-1137-4BA4-9272-EB25DD3963A6@microsoft.com...
> We're going to be upgrading our in place SQL 2000 server to 2005 and I was
> wondering if anyone could post up any gotchas or things to look out for?
> Thanks!!

"OverSeer" <OverSeer@discussions.microsoft.com> wrote in message
news:EEF638EC-1137-4BA4-9272-EB25DD3963A6@microsoft.com...
> We're going to be upgrading our in place SQL 2000 server to 2005 and I was
> wondering if anyone could post up any gotchas or things to look out for?
> Thanks!!

http://msdn.microsoft.com/en-us/library/ms143232.aspx

--
David Portas

"OverSeer" wrote:

> We're going to be upgrading our in place SQL 2000 server to 2005 and I was
> wondering if anyone could post up any gotchas or things to look out for?
> Thanks!!

To expand upon this topic. Has anyone seen any performance issues after
upgrading from 2000 to 2005?

OverSeer,

Well, sure. Nothing is ever perfect. One big thing is to update statistics
after the upgrade. And it is possible that some statements will run slower
due to optimizer changes and, if so, examine them for improvements.

On the whole, though, it all runs measurably faster.

RLF

"OverSeer" <OverSeer@discussions.microsoft.com> wrote in message
news:E48DA3AD-3648-4387-8450-C2BF9F5F2AF6@microsoft.com...
> "OverSeer" wrote:
>
>> We're going to be upgrading our in place SQL 2000 server to 2005 and I
>> was
>> wondering if anyone could post up any gotchas or things to look out for?
>> Thanks!!
>
> To expand upon this topic. Has anyone seen any performance issues after
> upgrading from 2000 to 2005?

Thanks a ton for the fast response Russell. We'll keep an eye on things!

"Russell Fields" wrote:

> OverSeer,
>
> Well, sure. Nothing is ever perfect. One big thing is to update statistics
> after the upgrade. And it is possible that some statements will run slower
> due to optimizer changes and, if so, examine them for improvements.
>
> On the whole, though, it all runs measurably faster.
>
> RLF
>
> "OverSeer" <OverSeer@discussions.microsoft.com> wrote in message
> news:E48DA3AD-3648-4387-8450-C2BF9F5F2AF6@microsoft.com...
> > "OverSeer" wrote:
> >
> >> We're going to be upgrading our in place SQL 2000 server to 2005 and I
> >> was
> >> wondering if anyone could post up any gotchas or things to look out for?
> >> Thanks!!
> >
> > To expand upon this topic. Has anyone seen any performance issues after
> > upgrading from 2000 to 2005?
>
>
>