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?

It was removed in 2005, added back in 2008.

I thought Gail was right here. Shouldn't use space for int/char if it's null, the null bitmap should carry that.

I'm not sure what you mean. Is it that Profiler in the SQL Server program group (for SQL Server 2000) isn't working?

It doesn't matter. You can use the SS2K5 version...

You should be able to connect by directly connecting to the port for that instance. So if you have a named instance, you need to set a specific port (port...