Also, a ref: Setting Up Windows Service Accounts.

Ultimately, no, there is no way to prevent a domain admin from accessing SQL Server. If the client owns the physical box, then they can get to everything. Not sure...

LOL, I was working at the nuclear station, about 40 miles from my house. Was a good opportunity as a grad student, so I did it. Loved it.

Got promoted, offer...

You would have to scan the trace information for deletes. You could use a trigger to capture delete info and drop it in another table.

I used to drive 110 miles each way for a job. Did that for about 6 months.

Tempdb is a database, like the others ones on your system. If it grows, it needs that space to grow. It does not shrink back down once a process is...

Not sure you can read the error log with T-SQL. It's just a text file, so you can scan it with FIND, TAIL or other command line utilities. The downside...

That's an interesting thought on the partitioning. I would think it would be an issue. If you go to SSDs, I think you want to use the entire drive as...

You're certainly not forced to pay for an upgrade, but why would you expect someone to upgrade a tool for free?

Will the database still be correct for testing if you have orphaned rows?

Typically you truncate the children, then the parents. That way your relationships are intact.

I don't believe you can do this with the mdf as well.

ALTER LOGIN (http://msdn.microsoft.com/en-us/library/ms189828%28SQL.90%29.aspx) doesn't map to users. the ALTER USER (http://msdn.microsoft.com/en-us/library/ms176060%28SQL.90%29.aspx) is what you use to connect the login to the user.

Are these mapped to users in the databases? Keep in mind that a new instance has it's own logins. If these are used by some process or there is some...

Doh, sorry George. Missed it. My apologies there.

We'll see if the OP responds there. I wonder if they'll go elsewhere.

A crazy requirement, to be sure.