The linked server should determine how the connection is made, or possibly defaults in the control panel for that account. If you hadn't changed anything, however, I'd expect they would...

A log backup does a truncate in that all records that were backed up are marked as free, and that space can be re-used. Your log is a bucket that...

You are missing some information here.

When do you execute the application role? You need to run a stored proc to invoke this. I believe that the temp table will not...

Also note that if you have clients using the SNAC client or a recent ADO.NET driver, you can add both servers in the connection string. Then when you stop...

I've only seen this with corruption. However in DR situations you have to restore master, which can be a nice challenge if you're not used to it.

Some of the third party backup tools (litespeed from Quest, SQL Backup from Red Gate) will restore an object from a backup.

If you want to do it yourself, let me...

What are you trying to accomplish? When you shell out, you aren't using your login, you're using a service account (or proxy) login. running explorer.exe won't get you anything.

Microsoft included tablediff in the product, however this isn't necessarily a trivial task. It takes some time and effort to get it working right.

I work for Red Gate, but I'd...

select from sys.databases?

Keep in mind that even with simple mode, the log can grow. If you don't break it into batches then each delete is logged, which can be a lot of...

I haven't seen anyone reporting issues with Resource being corrupt and needing to restore. Since you can just copy the same DB from any instance back to your server if...

The resource database tracks system objects at a particular SP level. The actual DLLs and SQLServer.exe are changed with the SPs, so you would need to uninstall/reinstall, as George mentioned.

I'm not sure I agree that SET ROWCOUNT is the issue in SQL 2000. I've used a similar method years ago in 2000 to delete large numbers of records and...

Yep, if you read the article they mention that they make heavy use of Windows 2008 R2 and HyperV

That means that you don't have any logins and users out of sync.

How did you move the objects?