Fairly simple Jeff, nothing special, the only issue was finding the @profile_name, I found this link which explained it all http://msdn.microsoft.com/en-us/library/ms174410.aspx

Best of luck.

--Send file embedded in the body...

Thanks,

Iam still mentally upgrading from 2000 - 2005 and was still trying to use SMTP mail. Configured the query with sp_send_dbmail and it works perfectly.

Thanks for all the feedback, I actually got it done by creating a flat text result from a stored proc. Although it was not XML generated it was a file...

Here is the format that the customer is requesting. Basically consists of the header info and then the data as a dataset nothing complex. I am not an expert in...

Thanks very much, it works perfectly.

rgds

denis

Hi Scott,

Thanks.. that did it, you learn something new every day.

Have a great holiday weekend, I will now I can rest with that problem resolved.

Denis

Thanks Andy,

That makes sense and explains why it would have appear to have started up correctly.

Enjoy the weekend.

Thanks DB,

To clarify things further I administer the linked server and am wanting the central DBA to enable this job to run. The message I get from the centre is...

We have been monitoring it and have found it is a blocking issue. When it started happening last week we could not even open the Current Activity section of EM...

Hi,

That was it, I did not realise I had to declare the @BTB BEFORE the execute of the stored procedure. All working well now..thanks.

Hi BK,

Have tried with sp5a and tried all configurations of sp_addserver i.e. making the remote server the primary server. Have been through BOL totally? Am totally lost now.

Any further...

Hi,

Thanks for assistance, will use solution proposed, I just need to find time when both DB's can be restarted!