What you will need is one (and only one) distributor, one publication and one subscription to that publication.

The subscription from the "second" database sorts out getting updates from both databases...

The fuzzy lookup task is not available with Standard Edition. It is only available in Enterprise and Developer editions. So, there is no bug related to your issue....

I am afraid you cannot do this with SSIS. Each column on the data flow can only have one data type. You are trying to use 2 data...

For push subscription - the distribution agent will be on the distributor

For pull subscription - the distribution agent will be on the subscriber

Try using 4 ? characters as the file name wildcard in the foreachloop container

e.g. ????.mdb

There is a bug with the code that implmenets the maintenance plan task to delete files. You need to install the update to correct the bug.

Something like the following is what you will need

SELECT

{[Measures].[Sales Amount] } * { [Calendar].[Month].members }

ON COLUMNS,

{ [Calendar].[Year].members }

ON ROWS

FROM [Sales Cube]

You will need to substitute the appropiate cube and...

I think that the following will give you the code you need to disable all scheduled reports

select 'exec msdb.dbo.sp_update_job @job_name = ''' + CONVERT (VARCHAR(50),RS.ScheduleID) + ''', @enabled=0'

from...

The short answer is - Yes, you do need to install SSIS on the client machine.

Your application needs to be able to load the SSIS binaries just the same as...

I can't see any way the you could initialise a your subscriptions from multiple publishing databases. You do need to restore a backup of each publishing database which would...

I think that you will also need to add a subscriber to the article (using sp_addsubscription)

FYI : replication is, typically, only interested in DML commands. Index rebuilds and the like are not of interest to replication. If you need to perform these sort...

With log shipping, any change made to the primary database is applied to the secondard database. This means any DDL change, permission, users etc.

Logins are actually in the master...

What I expect to happen is that when servera fails, your application will receive an error and it needs to deal with that error. What your application needs to...

(DT_i4) returns a 4 bytes integer. If you need a smallint, you should use (DT_i2) instead