I have just completed the design and implementation of a warehouse using Enterprise Architect as the design tool. It worked really well for us.

You can use it own...

I kinda suspect that when you sync that databases during the day, you create a new snapshot. The generation of the snapshot will be what is causing the locks.

To...

Make sure you thoroughly test what you have done. The trigger exists for a reason (someone at Microsoft put it there for a reason). If something goes wrong,...

No - the snapshot agent is only responsible for create the various schema files and the data from the publishing database. It is not responsible for anything to do...

My post definitely applies to transactional replication.

I have just tried to add a column to a merge publication. First at the subscriber...got the same error you did....

I think that the articles you are reading are missing the point a bit. At best, snapshot replication might be similar to mirroring plus a database snapshot.

Mirroring definitely does...

The OBJECT_NAME function is running against the database where the query was run from. In the case of you first usage (SELECT * FROM MyServer.MyDB.sys.columns WHERE object_name(object_id) = 'MyTableName')...

Whilst you can change the SID if needed to match the SID of the User, you can avoid the problem by specifying the SID when you create the LOGIN on...

Underneath the wrapper, replication uses T-SQL to do its work. There is no particular restriction imposed by 32 bit Vs 64 bit so you should be OK

The error message says it all.

the /ENCRYPT switch has mandatory parameters. The syntax for this switch is

/En[crypt] {SQL | FILE}; Path;ProtectionLevel[;password]

Have a look at "Dtutil"...

Search for MDX at http://Www.databasejournal.com. You will finds a stack of articles and tutorials on MDX

Until you get SQL Server to open the database (e.g. per my my previous post), you will not be able to very much with the database.

There is no reason not to add another sub-report and navigate to it from the 1st sub-report. If this is how the work flow seems to work best,...

Launch Replication Monitor, navigate to the publication, select the "Warnings and Agents" tab and then right click on the "Log Reader Agent" and select properties.

This will show you...

When you set up the navigation for the user name field on the report, you need to click on "Parameters" and associate the user name parameter of the sub-report you...