SQL Server tracks dependencies (e.g. in sys.sysdepends) if the referenced objects exist when referencing object is created. The information in sys.sysdepends is only used for documentation purposes - it...

FYI : Merge Replication is not real time. From memory, it is every 2 minutes. You can change this if you need.

The architecture of Merge Replication...

When you (or SQL Agent) authenticates to Active Directory (when you logon or start a service), a "ticket" is issued that represents you. This ticket is valid for a...

Transactional replication is quite happy to have a subscriber that already has the data - hence avoiding the need to use a snapshot. If you choose this option,...

Not only can you use Username as part of an MDX expression to filter the set of visible member, you can also call a .net assembly to apply your security...

A differential backup backs up any pages that have been changes since the last full backup. It is not affected by changing recovery models.

OLAP Heartbeat is currently a free third party tool. There are plenty of hits of Google.

You can download from http://www.sqlsolutions.com/products/olapheartbeat/index.html

I expect that this error is because you are trying to restore MSDB from an earlier version of SQL Server.

If you did manage to restore it, I would expect that...

Have a look at "OLAP Heartbeat" - gives you a really cool graphical interface that shows the OLAP processes that are running.

Oops, that should be the DTEXEC utility

you need to have some process that will run the package. Installing a package on a server is not much more than simply copy the .DTSX file to the...

From memory, each of the SSIS objects has a unique ID. This may have changed when you installed SQL2008. I suspect the SSIS designer looks up the ID...

Are you planning to script out your database objects ? If yes, then this is where the permissions should be scripted - there is an option to script permissions...

Is the "PreCompile" property of the script task set to TRUE in BIDS ? When running on a 64 bit installation, SSIS script tasks must be pre-compiled.

You could change the subscriptions so that they used shared agents instead of independent agents (which is the default). Independent agents give you better performance than shared agents but...