ok...maybe i am just not seeing it...i can detach with out a prob. when i reattach how do i specify where the new location will be? In this...

THANKS. NO ONE SEEMED TO UNDERSTAND MY PROBLEM BUT YOU. I APPRECIATE THE INFO.

ELIZABETH

Elizabeth

perfect! Thanks

Elizabeth

Elizabeth

GOT IT! YEAAA! Thank you all so much!

Elizabeth

Elizabeth

ok. the profile name is sqlserver. it is on each of the three locations (sql server agent, send mail task, and outlook). I see what you guys...

Thanks. I will check that out now. Do you have to have outlook installed on the box that the main sql server is on?

Elizabeth

Elizabeth

The only problem is that the variable is the database and server name. I tried putting ? but it would not take it if it was before the where clause.

Elizabeth...