Do you have a baseline of how your procedures should perform? We have a daily trace setup on each of our production servers that we load into our DBA...

In addtion to the above which is the most likely scenario. Are you using any filters in your indexes and are you copying all attributes as part of your...

This may help:

http://technet.microsoft.com/en-us/library/ms162843(v=sql.105).aspx

This is the native tablediff utility that shipsd with SQL server.

Reoraginzing \ Rebuildind indexs will generate a large amount of Transaction log activity. You can reduce the effect by changing the recovery model pre maintenance to Bulk-Logged or simple...

Have you looked at the native SQL Audit, I am pretty sure that you can do this using an audit specification. Be aware though that it can log a...

It will depend on how your server is setup, but can you log on to the server as the account your SQL Agent runs under and run the package interactivly...

You have mentioned that it runs fine in BIDS, where are you running BIDS on the server that the SQL Agent job is running from or from your workstation?

Have you checked that the account the SQL Agent service runs under has the neccessary permissions to access the FTP folder? It sounds like it is not populating the...

Are you running the package from within a SQL Agent Job or interactivly when you get this error?

Looking at the output I would suspect that it is from a SQL...

I personally would remove the passive node from the cluster and reinstall. Remember when adding a node to the cluster all setup options are taken from the active node...

If I understand your setup correctly you can communicate between the two SQL servers over the same network so I am assuming they are on the same domain?

If so you...

If I understand your auestion correctly, then no you cannot use the node name I.e DBSERVERA as the server names on a windows domain must be unique and any cluster...

No, when creating a cluster you will assign a virtual machine name (not the same as a VM OS) this is then the name you will use in your connection...

This is one method, it will at the very least give you a basis to create your own code should it give you exactly the result set you are looking...

The performance of a query on your standby logshipped destination database should be exactly same as the source providing the servers are of an identicle specification.

Have you looked at the...