Create a single connection to a dummy access database and use a file system task and a loop container to copy each of your databases to that file name /...

I wish my situation was as simple as two servers...  One thing you could do is put two instances of SQL on your server - multiple instances do not need...

Crazy as it sounds, if you change your database mail configurations, you have to re-start the MSSQL Server Service to get many of them to apply. 

Visio can read your database structure and display the tables and foreign keys.

You should not find significant performance differences in cross-database queries assuming you fully qualify all of your object names.  You do have to watch out for cross-database security chains.  This...

Views have to meet some specific criteria to be updatable.  For a quick test, try updating a record wih a SQL statement rather than using the SSMS grid.  If you...

One thought - after you change mail settings in SQL 2005, you have to stop and start the SQL service before they will be applied.

Everyone is trying to help, it is just difficult to give a real answer without being able to reproduce the issue.  If you have lost the source code for this, I think...

Is your application using DTC to manage transactions?  We have a problem from time-to-time in which DTC basically refuses to close a transaction and release all of it's locks.  We...

Everyone is right - post the entire code and it will be much easier to assist you.

By any chance, are your dev and test servers single-processor servers or some kind...

Under your miscellaneous agents in the replication monitor, there is distributor clean up agent.  This agent runs sp_MSdistribution_cleanup which runs sp_MSdistribution_delete which in turn runs sp_MSdelete_publisherdb_trans.

Make sure the agent has...

Do not put too much time into why the databases are different sizes.  I do not know what you have set up for each of your articles, but replication does...

We have a similar situation in which we have implemented a master data solution using transactional replication.  Here was my thought process:

Linked servers were out because of two things -...

That was a great answer and I want to add to it that the clustered index also has a big impact on inserts and updates.  Remember that if you update...

First, transactional replication is not a replacement for clustering - which is what you really want to do.  It is not a great failover solution since it cannot automatically redirect...