Lynn Pettis (5/9/2008)
So, would you improve the question, or the answers provided? To take this into an interview environment, I would be looking to see if someone knew that there were 5 system databases: master, model, msdb, tempdb and resource. It wouldn't matter as much to me if they could provide me with the logical or physical names. You can look that up in BOL or in the file system.😎
So I'm reading all of this feedback intently because I've never heard of the Resource database (I've been using 2k5 since beta), and now I find out I would fail your job interview question.:crying:
I guess I want to know what is there that is worthwhile about knowing about it's existence? When you setup a Maintenance plan for the System databases, does it include the Resource database? Has anyone in this discussion ever gotten any use from the Resource database, or from knowing of it's existence?:ermm: