any issues with sql2k on win2k3?

we're about to upgrade from
win2000, sql2000 sp3a standard edition, dual p3 900mhz, 2gb ram
to
win2003, sql2000 sp3a standard edition, dual xeon 3ghz hyperthreaded,
2gb ram
the only issue i could find at microsoft was the sql install issue
where win2003 wants sql sp3. any other issues to watch for?
do some people claim better performance by limiting sql server to use
only the two physical processors instead of the two physical processors
and the two logical processors?"ch" <ch@.dontemailme.com> wrote in message
news:41A36D56.E36EF4A7@.dontemailme.com...
> we're about to upgrade from
> win2000, sql2000 sp3a standard edition, dual p3 900mhz, 2gb ram
> to
> win2003, sql2000 sp3a standard edition, dual xeon 3ghz hyperthreaded,
> 2gb ram
> the only issue i could find at microsoft was the sql install issue
> where win2003 wants sql sp3. any other issues to watch for?
I think you're covered, operating systems are comparable? In otherwords,
Windows 2000 Standard and Windows 2003 Standard?
> do some people claim better performance by limiting sql server to use
> only the two physical processors instead of the two physical processors
> and the two logical processors?
I prefer not to tinker with processor settings, rather allow the operating
system to manage the processors. in addition, Windows Server 2003 and SQL
Server 2000 does a fairly good job of dynamic memory and interfacing with
the processors. You could always run some benchmarks as there are always
certain situations, applications, etc where manual intervention may be
warranted.
Steve

Any embedded tool in win2003 or SSIS for extracting the files from ZIP

Who knows whether exists embedded tool in win2003 or SSIS for extracting the files from ZIP?

Thanks in advance.

SSIS can execute a command line zip utility to extract files.|||

Do u mean that it should use 3rd party tool(like winzip command line)?

I dont wanna do that cuz of commercial purpose.

I just wanna know any tool in windows 2003 server or something banding in the SSIS

|||You're going to have to use a 3rd party utility.