This is good... Do I dare jinks my day with answering on the side of traditional beliefs or transcend the norm by speaking in the affirmative?

hmmm....

Unless I'm missing something here, have you tried "or-ing" the results?

Here's my quick and dirt solution, excluding the table creation and inserts code...

select

t1.id,

Name =

I appreciated Ron West's followup posting of dynamically setting up email profiles/accounts via TSQL. I was recently questioned on sql05 abilities of producing emails with varible originating names which I know can...

sp_helpserver should give you the necessary info...

What is the database recovery model set to i.e. Full, Simple, or Bulk-logged?

I, for one, didn't notice the category but my thinking was that anything is possible in SQL if you know how to get at it and make it happen.  BUT...