I have also had the problem with performance over link servers. One thing i found was when to much data is retrieved or tables are used in the queries it...

Do still have the problem or did you reinstall because, i am using SQL2005 SP2 Database Mail on a 64 bit Dell server and it works fine.

I have a script...

Thanx for all your help. I will try it but was actually also looking for SQL code like the previous examples.

Manie

womalley,

This one is much faster and better. Can you manage to get something that scripts JOBS? I tried it with these but to no avail. I know that the jobs...

womalley

Thanx this really great

Manie

Thanx, will try it

Hi CVM

It is exactly what i want.

Manie

Hi Frank,

I know how to do that. I want to creat a procedure that can do it for me. I want actual SQL code. for expl. select * from....

Thanks

Manie

...