I think you're stuck with uninstall/reinstall.

There are a few blog applications out there, like .Text from Microsoft that you can download and examine the schema.

Can't be done.

Detach dbs, script logins, uninstall, reinstall.

This doesn't really matter, as long as you have the paper to support what you are running.

If you are doing this because you need to move the CPU license to...

There are multiple versions now, a light version (LT) that's smaller, a datawarehouse version, the regular one, etc.

Do it for one server, then build a set of scripts to pull this together. It sounds like busy work, since this is just documentation and the location can change...

It used to be that when you deleted a database file, the physical files were not removed. so you could attach them again. That doesn't happen any more.

The mirror database should be in the restoring status. It is in that state so that new logs can be applied to the database.

If the principal goes down, then you may or may not be able to get a mail.

http://msdn.microsoft.com/en-us/library/ms408393.aspx

http://www.petri.co.il/mount_iso_files_in_windows_vista.htm

http://lifehacker.com/180124/mount-an-iso-file-without-burning-a-disk

didn't notice the comma, but I realized the intent of the question.

People hire people. Interviews are where a candidate makes an impression. But when narrowing down who to bring to an interview, or in who a recruiter can help sell to...

That profiler statement shows a creation of a temp table and then an insert of logspace information. Nothing should be happening in the model database. If you set the model...

I agree with Luke. If you start a tran, the optimizer doesn't lock everything referenced.

Begin tran

waitfor('1:00:00')

update sales

set price = price * 1.5

commit tran

The sales table will not be...

Run Profiler, set to filter to the model database and look for activity. Something is occurring in there.