The DTS packages will load fine. If you want to back the up to a disserent server then download DTSBackup 2000.
I can't ecall the mas RAM but it goes up to at least 16GB.
You will have to alter you boot.ini file for the OS to use any RAM over 4GB (Enterprise edition for OS). And you will have to run sp-configure 'AWE enabled', 'true'. And lastly you will have to fix the memory that SQL can use ( can't use Dyanamic mem allocation for AWE)
--------------------------
Sent from my BlackBerry Wireless Handheld
-----Original Message-----
From: Christopher Stumpo <mssqldba-ezmlmshield-x3711277.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Fri Sep 29 07:46:17 2006
Subject: Re: SQL Server vs Enterprise Edition
I currently have a SQL Server 2000 SE running with lots of DTS packages.
I am planning on upgrading to 2000 Enterprise Edition but have the
following questions.
1. Will DTS packages in 2000SE load into 2000 Enterprise Edition
2. What's the max ram you can run on 2000 Enterprise Edition
3. Can you configure the ram changes within GUI or do you need to run a
back end process
Any information you can provide would be appreciated.
CS
>>> "Phillip Carswell "
<mssqldba-ezmlmshield-x60252070.[Email address protected] 09/29/06 10:29
AM >>>
Does anyone have any ideas on how to track ODBC Connections in SQL
Server 2000. We have a 3rd party application that uses the same ODBC
connection for every process. I just wanted to know if there is a way to
extract more information from the connection such as ip address, user
logged into machine connected etc.
Thanks
<<Picture (Metafile)>>
Phillip Carswell
Database Administrator
Network Communications Inc.
Phone: 770-962-7220 ext. 24522
Email: [Email address protected] <mailto:[Email address protected]
www.nci.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message is for the exclusive and confidential use of the addressee. Any other distribution, use, reproduction or alteration of the information contained in this electronic message, by the addressee or by any other recipient, without the prior written consent of the sender is strictly prohibited. If you have received this electronic message in error, please notify the sender.
MS Sql Server LazyDBA home page