Back it up to local directory, then another script/Job will copy it over to the WAN using SCP

Open the Job Activity monitor in a separate window and then right click.

Hahahahah... That was funny...

Thanks Grant..That what I thought.. But couldnt get any details of the certificate with the query I gave him.

Gail it is your secret admirer for sure... 🙂

He just did not have the guts (Or he is scared out of his pants about your reaction) to put his name...

What is the user that is running the Replication Agent? And also what is the user that is running the SQL Server Agent? They both need to have modify permission...

As per BOL... The following example disables trace flags 3205 and 260 globally.

DBCC TRACEOFF (3205, 260, -1);

GO

Where -1 means global.

When they updated the DB , did they add any trace flags? Seems like they have DBCC TRACEON(3607), DBCC TRACEON(3608) and DBCC TRACEON(3609). This can cause SQL server to...

Can someone take a look at this issue?? I am bit lost on how to help this OP.

This error comes up when there is a master key set up for your 2008 or 2005 box. I am a bit lost here. I will try to get some...

Try this query...

USE master;

GO

SELECT * FROM sys.symmetric_keys WHERE name LIKE '%MS_DatabaseMasterKey%'

GO

Do you have encryption set up on your publisher or subscriber? That is when you get the master key errors.

Glad to know that everything worked out fine...

I sit in a corner with another DBA and one network admin who is allowed to acces our Main Database server. I have the gif file printed of WTF reviews......

Your issue is a small one. You cannot add a 2008 subscriber from the 2005 SSMS. This is due to the fact that SSMS is only backward compatible and not...