We were thinking about writing a wrapper but trying to avoid it.   I think this may be our only option.

Turned out to be some orphaned transactions.  i cleaned them up manually through the distribution DB.  I'm not sure how this could have happened.  I used the UI to delete...

Thanks man..

This publication only had one article (don't ask me why, was scripted by another DBA).

I refreshed the monitor but it still tries to push the transaction.

You are correct.  The Backup command has to be run with a connection to the server the database is located.  The Restore command has to be run with a connection...

Tables and data are doable through DTS import/export.  Essentially your data source would be Microsoft Oracle OBDC and your destination SQL Server.   Choose the tables you want to copy and...

another thought would be to have two data transformation tasks.  One would only start if the column count was 4, the other would only start if the column count was...

Fairly easy.  Here are some high level steps:

1. Select the results of "xp_cmdshell 'dir c:\import'" into a temp table. (you'll have to fool with the command line switches).  Select the top...

A few ideas:

1.  Are you executing the package from a structured storage file or is it saved in SQL?   Sounds like it's a structured storage file.   Try saving it in...

If you delete the product you will not be able to see any of the profile data since the key relationship will be broken. 

It is actually a bad practice to...

You need to surround your paths with double quotes.  

i'd suggest the 3GB switch with max server memory set to 2.5.   Keep an eye on your free memory and non-paged pool.

it sounds as though your SQL server may be...

Basic high level answers:

RAID:

• RAID 5 or RAID 10 for DATA.  The number of spindles will depend on the amount of disk IO.  You may want to split your data files...

This is handled outside of the database maintenance plan you used to establish log shipping.  You disable this at the Job level on the secondary server.  Just right click -properties...

it really depends on what type of testing you plan on doing.

Our test environment (dual 2.4 w/ 4 gig) is not as beefy as our production environment (quad 3.2 w/8gig).  We have...

If you are referring to the Job "Log Shipping Alert Job - Backup" on the secondary this job should be disabled.  This job is only to be enabled on the...