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


MS Sql Server LazyDBA home page