You should treat MSDE the same as SQL Server as far as fix levels, security setup, etc is concerned. There are many hacks out there that allow you to...

The following link may be interesting: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B328551

It looks like you can get some blocking within TempDB if TempDB has a lot of pressure from heavy workfile and/or temporary table create...

Quote: "The maximum (theoretical) size of a database is 1,048,516 TB, and not a single terrabyte as earlier suggested."

Don't forget you can have up to 32768 databases per server. ...

We run with SQL Logging all logons, and NT auditing set on for most things. There have been a few situations where people have claimed the DBAs 'must have'...

I just leave MSDB in simple mode, but do a full backup of MSDB shortly after my other backups are finished.

I do transaction log backups of the 'real'...

A few things to remember...

a) Space may be needed to process the transaction log, as well as database.

SQL Server will always scan the transaction log and to back...