Correct me if i am wrong. To my understanding when u do a full backup the transaction log is also backedup and truncated. By doing full backup the log is...

Though the article on MSFT link says for SQL 2000, but we did have this problem on SQL 7.0. The error was similar, but with a different error no. ...

U can try to increase the no of locks . my guess would be too many processes starting at the same time, i mean jobs. SQL server has a known...

there are issues with SQL2000 and OUTLOOK 2000. u need to search on MS KB site. There is an article on this issue.

When u j=have multiple select statements querying the same subset of data there are chances that shared lock becomes deadlocked. I have experienced these issues before. And sometimes there might...

VirusScan can eat up CPU Usage

SQL 2000 has many enhancements in area of memory allocation. Based on your requirement you can set the parameter. If you go through the enhancements you should be able to...

Who owns the package, if its different from the owner its saves it as the new user.package name.

Are u the owner of the DTS package?

U don't need to shutdown sql server to reset suspect status, but i am not sure about MSDB db requirments. In general you should have SA rights to use sp_reconfigure...

When u define sql server to use all available memory(which is recommended) it uses max available. yes that includes agent service as well.

U can run a profiler when the job runs and see where it bums and act accordingly.

u may want to check the column mappings i.e the columns to where the data is getting into at the excel end. In the preview itself you can check the...

According to documentation it doesn't say so other then the limitation of columns on a table.

"You'd use detach to avoid stopping the service on the original server"

So does that mean that the database files can be detached while the database is operational???