This needs all the power you can get. This time it has to be torpedoes.... 😛

I think the OP wants to do it as part of the Script.

As per BOL

The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin...

Why not try to give the db_ddladmin role to that user. Maybe that user does a Truncate command or Drop command or Alter command.

Check the MSDistribution_status view in the distributor. Maybe that will give an idea where you have to look.

Just as an update, The firmware was wrong and the network teaming is also messed up. We are going to do a Shutdown tonight to fix these issues. If it...

I have seen the full series. I actually loved it when it was Captain Kirk, Spock and Doc. 🙂

I wanted to see it but couldnt. Maybe this week. I love Star Trek.. 🙂

I was starting to get a bit paranoid about the well being of THE THREAD. But hopefully that will change now.. 😛

I second that. Use Third party software only when you cannot use the Native methods provided.

Thats a tricky situation. The reason behind it is

1. If you set up distributor on the production, then you have more load on the production Server (But that depends...

If you set up...

Why not make a Cluster of two servers with a shared Disk as your Primary server (Active/Passive) and then set the Log shipping for DR?

Then you dont have to bother...

Remember to read up a lot about SQL Server and DBA issues that everyone is facing daily so you will be more prepared when you do get a chance.

BOL should...

You can set up the DR with Log shipping from SQL Server itself. Set to log ship every min. The Max data that you can loose would be 5 min...