Did the Oracle Instances get updated to 10g, or was it the client tools on your SQL Server box.

I would consider the following:

Can you upgrade to SQL Server 2000 sp4

What...

I have been part of a team that implemented that at a public company under SOX compliance.

It has been well received because they knew changes were being done by our...

Have you thought about adding yourself as a sysadmin and then you can have a job running on each of the servers that randomizes the SA password every 30/60/90 days....

What are you looking at to tell you the amount of memory SQL Server is using? If I recall 1 of the perf counters doesn't report the value accurately....

Have you set the maximum memory on SQL Server? You would want to set the maximum SQL Server can have to at least 1 Gig lower than your server...

I would agree with Jane. I have been a DBA for almost 4 years. For me the hard thing is to transition from the person who reads...

I have had similar issue with a database in 8.0 compatibility mode. When I specified the database id the query worked ok for me.

You might also want to look at the data conversion task?

If you right click on the Built IN Admin user in Mgmt Studio and select properties you should be able to click on the Server Roles tab and view what...

Is this login for a user that has administrative rights to the box?  Sounds like you have a local admin accessing the database server through Builtin Admin rights to the...

I have used similar packages with DTS, but we had to end up going with a tool like PKZip which will work from commandline.  We had similar issue where package would...

To actually open/edit the packages you can open BI Studio and create a new integration services project.  From here you right click on SSIS Packages and choose add existing package. ...

Seems like when you use the migration wizard you have to specify which packages you want to upgrade, and also how you want to store the newly created packages.  You...

My 2 cents would be to try using the wizard first and test the packages it creates for you.  I have used it to upgrade several packages that were a...

Thanks for the help.

It looks like you have been working with some things I was messing around with.  Hopefully it hasn't been too bad cleaning up my messes.