Wow, that's surprising. Wonder if that happens in 2008. I'll have to check that.

I'd pass in the stuff you have, then maybe query information_schema.columns for the table name, get the columns. You can concatenate those in a query and then build a string...

I'd really love to hear what other people think is a "healthy" database. Hmm, maybe that would be a good Friday poll 😉

I think that health has to be measured...

With merge, it's publisher/subscriber, but not really. If one server goes down, the other one still has all the data it should (or that's committed). If you have a load...

Replication does not delete anything. It copies transactions from the publisher to the subscribers.

Unless you have merge setup, as mentioned above, it should not move data from the subscriber to...

You should remove the triggers as they're not helping. The people querying the variables will do as well against the table. You can query with a NOLOCK, and set a...

Nope, as explained above.

Please post what you've tried and some information about the tables.

You need a MAPI client (Outlook or equivalent)

http://www.sqlservercentral.com/articles/SQLMail/sqlmailusingpop3andsmtp/1577/

http://www.sqlservercentral.com/articles/Administering/sqlmailresources/605/

You can't survive a kill. If someone has authority to kill your process, SQL Server will do an orderly kill and roll back the work.

It's not a simple process and you will have downtime.

Backup / restore will move the databases, and you can stage this to minimize time. Do a full backup, move that,...

apexsql.com (apex log tool)

Don't forget DDL triggers.

Also, please don't cross post. We scan all forums. The others were deleted.

What is the problem/error or what are looking for?