Sorry, if you didn't detach/attach, how did you move the objects?

If you copied them over, the permissions aren't there. You can use the Generate script function of SSMS to move...

All your user permissions and objects will get moved with an attach. The only thing that you might be missing is the logins. sp_change_users_login with the report option should help...

Read this:

http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/

tempdb doesn't write sequentially. The best thing you can do is separate out tempdb if it is getting used heavily.

If settings are not mentioned, assume the US English defaults.

DR is a good point.

As far as a target, that's possible, but this is an R&D lab. Presumably there is no issue for the company running if it were to...

My son reads the editorial scripts at times. He asked me what "it" was and why did I capitalize it?

Terrible shirt?!?!

If you get errors from DBCC, I'd start a new thread in the data corruption thread and post it there.

Please post here: http://www.sqlservercentral.com/Forums/Topic787173-338-1.aspx

I think Lowell has some good ideas. I'd use the checksum to get an initial list, but then I'd have some program run through and compare the binary data to...

No worries. We're working to slowly improve things over time. New hardware is being spec'ed and argued about now, and I think that will help.

I suffer the same issue here....

How did you change this? You should be using Enterprise Manager.

When you say support, do you mean performance, availability, or both? Clustering only helps with availability, it doesn't address performance at all. In fact, it might be worse availability than...

Can you send a test message? I'd be sure the profile is still valid.

The client has to handle the color coding. It's not a SQL function.