If you want to try a new technology, Powershell can do this.

Do you want info inside SQL Server for something?

there are a few tools that can do this, however it's pretty simple to write this as mentioned above. Lots of scripts here on this site as well that can...

Output the SQLCMD stuff to the same file, appending the data from each. Then you can dig in and build a report.

Master really needs logins moved (and roles)

msdb needs jobs, maint plans, etc. moved. You might be able to script all this stuff out.

Model, what needs to be moved?

I'm not sure what the default time that the data is stored, but I bet that if the report only goes back 10 days, the data is gone. This isn't...

I believe the server security_admin can be given to fix this.

Or set up a job that can run under system context and run sp_change_users_login to sync things up. The logins...

You need a variable to do this.

select @cmd = 'update tableA set '

-- cursor start here

select @cmd = @cmd + @column_name + '= ''value'' where ' + @column_name + '...

There could be lots of reasons, but likely the application is not dealing with the time it takes for something to occur or the load of data being moved.

You haven't...

This isn't something you change with T-SQL, it would be done in the Configuration Manager in 2005 or the Server network Utility in 2000.

select a.value, b.value

from tableA a

inner join tableA b

on a.id = b.parentid

Queries against master have no impact on the server other than using resources to execute the query. There is not reason this should corrupt anything.

If you get this with a local backup, you have IO subsystem issues.

The mirror's always in "recovering" state, waiting for more transactions. If you turn it off, it might be expecting that you'll turn it on, and I wouldn't want the SQL...

Do you mean indexed views?

More details would help. It would be good to know as well what the input rate is, perhaps using a trace to determine where things are...

I'd think merge as well. Is the same data potentially being updated as well in both locations? If so, you need something like merge, or write your own merge, which...