Thanks, I guess my assumptions were right. I will remove the log shipping, restore and then recreate the log shipping. Thanks for the help.

Linda,

That sounds like a good idea. I will look into that, I'm just concerned about the locking issue with the reindexing, I'm not sure how much we can spread it...

Thanks for your response Ray. Believe me I understand that reindexing causes the log backups to grow. That is why I am thinking about changing it from weekly to monthly...

Phil and rschaeferhig,

Thanks to both of you for your help. I have successfully set up my DTS package with the global variables needed to accept the SQL...

Good Morning Phil,

In your regards to your reply:

I've no idea why the email wouldn't have been received. Maybe a firewall/port mapping issue ??

I am no expert on network issues, but if...

Ian,

Thank you for your reply. When I originally setup the SQL Server to Oracle replication I tried both providers, the oracle provider resulted in the replicated data being case...

Good Morning Phill,

Thanks again for your help and advice to my problem. As I said earlier I did install xp_smtp_sendmail on one of our development servers that is running the...

Thank you so much for the reply, this is exactly what I want to do. The only global variable I want to define is the message though and I want...

Phill,

I agree that I am probably making it more complicated than it needs to be, but I am just trying to find something that will work on this server that has...

Hi Phill,

Thank you for your response. Actually, we have our alerts setup similarly on our other servers. The alerts execute a sql server job that sends a formatted e-mail with...

The problem with connecting to the distributor from the publisher turned out to be due to firewall settings, so this has been resolved. Hopefully, I won't have any problems setting...

We use a VB script to do something simiar to this and run it from a centralized server that has SQL Server client installed on it and can connect to...

Igor,

You may want to try increasing the Delay between responses setting on the Response tab of the alert. It is set to 1 minute by default.

HTH.......Michelle

Phil,

Thanks for your help. I think that it works now. The true test will be the next time the replication fails. I guess now I have to figure out why...

Phill,

I think the problem is I had my @Msg variable wrong. I had it as:

SET @Msg = 'Error: [A-ERR]' + CHAR(10) + 'Severity: [A-SEV]' + CHAR(10) + 'Date: [STRTDT]' +...