I would suggest that you do a little reading about both transactional and merge replication. Architecturally, they are very different ways do replicate data and you really should understand...

Using T-SQL it is not so easy.

However, since you are planning to use SQL Agent, why not just use the step type of "SQL Server Analysis Services Command". You...

That's exactly what I do.

The only other option I can think of involves restoring to a point in time prior to your delete - definitely more cumbersome...

Not sure of the context. However, have a look at either FILTER or EXCEPT. They should be able to do what you need.

You are on the right track with the NOW() function. However, you will need to format the string to match the member name. Not sure what the answer...

This is pretty straightforward - create a constraint, then right click the constraint and select "Edit".

Change the "Evaluation operation" to "Expression and constraint". Add your condition to the expression...

Steve's reply is close.

Yes, once the each update has been applied to the subscriber, the record in the distribution database may be deleted. However, this is not done immediately....

There are many licensing options - you really need to know what your organisation has purchased.

In fact, without that, any advice you get (including this advice) does not really tell...

The client tools are...

SQL Server Business Intelligence Development Studio - this is used by AS developers to define dimensions, cubes etc

SQL Server Managment Studio - used to administer cube once...

With Transaction Replication, the size of the distribution database is more closely related to the number of transactions against the publishing database than the size of the publishing database. ...

2 things are wrong....

If you use the "END" statement, it must be paired up with a "BEGIN" statement. In you code, you don't need the END statement, so remove it.

The...

With SQL 2005, you can get replication to do most of the work for you. To get this in place, the publication should be created with @replicate_ddl = 1....

I suspect that your problem is happening because of some implicit type conversions.

The string 'insert into ' is not unicode, nor is @tablo or @dil. When you...

You have missed a step - you need to add a subscription to the new article. Once that is done, the distribution agent becomes aware that it needs to...

A database snapshot contains the data as it was when the snapshot was created. This applies to all things in the database including system objects. So, updating statistics...