Unfortunately, much of the user-defined objects within the databases are not sharable between databases. That is true even if the definitions are identical.

You can give this article a try...

It can be done either way. If it is easier to maintain all your applications' data in a single database then that is your business case.

However, setting up separate...

How about creating a view with all columns in the table except those you want to hide. Then give read permission ONLY to those views.

Probably empty space left by deletions. Try shrinking the database and see if the unused space goes away. It should.

Unless the applications need to share a large chunk of common data, which it does not sound like it is the case here, I would always create separate databases for...

This will most likely error out. If I remember right, you can only have one action per MATCHED. I think the INSERT statement will be interpretted as the...

Just a random thought: have you tried

and a.APPLICATION_DT >= '2012-08-01 00:00:00.00'?

Or

and a.APPLICATION_DT >= '2012-08-01 T00:00:00.00'?

The space is typically required as a delimiter.

Depending on your goals for the replication, there are a couple of products you can look at.

If you are looking at almost instance recovery from disaster then Red Gate (red-gate.com)...

There should be a link at the bottom of each screen that enables you to provide feedback on the content.

If there is already a clustered index on the table, then I would make sure that the PK is not clustered. This will help preserve your current performance.

As for...

SUBSTRING(FiscalYear, 5, 3)

You do not have to turn FILESTREAM on in order to store BLOB files in SQL 2008/R2 unless the files you want to store are larger than 2GB.

When I researched...

Just so I understand...

You are being asked to provide a comparison between the mirrored DB and the offline DB during a disaster, before the mirrored DB goes online?

If this is...

Very nice! That last one solved my problem.

Thanks a ton!

Jerry

Does the ar_cusomter table have an XML data column? I found that moving data with an XML column between servers is not allowed when using linked servers. I...