I have never been able to accomplish this when usernames and passwords are used. The passwords are stored encrypted elsewhere. If possible you might want to use trusted...

Please do not cross-post. Please make comments to:

http://www.sqlservercentral.com/Forums/Topic903476-1550-1.aspx

CEWII

Please do not cross-post. Please make comments to:

http://www.sqlservercentral.com/Forums/Topic903476-1550-1.aspx

CEWII

I don't have 2005 on my machine anymore so I am trying to answer using the 2008 RS Config Manager.

On the Web Service URL page what does it say?

On the...

Well said.

CEWII

I have to admit I don't often see Log Shipping as a method used to maintain a Dev environment. I would ask why this is being done? Or...

First of all I would steer clear of DoubleTake, my opinion. I've been subjected to nothing but pain by that package.

As far as data movement. I am generally...

If you have it available SAN replication is often VERY VERY good at DR/HA solutions. I would absolutely recommend AGAINST DoubleTake. I'd rather take a hot poker in...

I'm certainly not saying that your .net experience isn't useful in SSIS, there are things that can more easily be done with a script task. However, data movement isn't...

Ok, that makes sense. I would be sure to include logic to make sure you don't create too many files. In other words, watch what assumptions are made....

I'm stabbing in the dark but what about an index on #f1 Application and User fields, they are used as join predicates. Also have you looked at the actual...

Funny, I was actually thinking of using SSIS and a For Each Loop to do this..

CEWII

You could call the sproc manually from SSMS with the "Include Actual Execution Plan" which would give you a wealth of information as to how it actually ran. You...

I know this isn't quite what you were talking about but it might fit the bill:

http://support.microsoft.com/kb/940286

Also, the backup method you are using is not typical. In most cases the...

You can deploy using the DTUtil.exe program.

Also, I STRONGLY recommend that you group the packages into directories, even if stored in MSDB. Otherwise you end up with a list...