Antares,

We have monitors set up from another server and i monitored the stored procedure, and it showed me high execution time.

I agree that MDAC might not be related but...

Thanks everyone for the help.

Thanks for the efforts Greg. If you want to use a remote SMTP server, cdonts does not support this and thus we have to use cdosys. I will try to...

Yes, you can do that.

But it will take a long time. I had 100 gigs of database and backed up the database over the network and it took over...

Thanks Greg,

Sorry for the late reply.

I tried using the procedure provided by you on our test environment and it is not working for Attachments. Secondly, the Server on which i...

Thanks Joachim. It works great. Can you let me know if you come to know a different way also?

Thanks once again for your help.

Steve,

We also use Tivoli and thought about implementing this solution, but then thought about the network traffic of copying all the files over the network. We ended up pushing the...

Antares,

I agree with you that it is a bad idea to create triggers on System Tables as per BOL. But is there any other way how we can come to...

Thanks a lot Klaas. That was the problem.

Thanks everybody for your help.

Klaas :

I will check that and let you know.

Thanks

Brian:

Yes they are the same databases everytime. And yesterday i saw almost 30 such entries between 5:15p.m. and 5:30 p.m.

I agree with that. We have over 100 databases on a cluster. We are using SQL Server 2000 under Advanced Server 2000. The services have not been restarted for almost...