I was confused by "all CLR objects owned by a user are always executed in the same AppDomain" which seems to contradict “one AppDomain per database per owner”.

James Lean (2/23/2011)

---

You CAN change the default backup directory using SSMS very easily:-

- From Object Explorer, right-click on the server and choose Facets.

- In the Facet dropdown, choose Server Settings.

-...

Thanks Steve. I picked the right answer but...

Good question and a good topic.

I agree, this was a hard question.

Another good question. I thought that the correct answer was one but had to create a database and verify with DBCC Loginfo.

Good question and a good topic.

I fell into the same trap. I overlooked the WHERE clause. Not sure I understand what the point of that was?

Absolutely, thanks for pointing that out!

I'm a fairly old DBA but even I had forgotten that we lost these days back in 1752.

I agree! We had this in Oracle PL/SQL 15 years ago!

mtillman-921105 (12/16/2010)

---

Cliff Jones (12/16/2010)

---

A very interesting question but I am not sure the answer is completely correct? Seems like the contents of the temp table would be within...

A very interesting question but I am not sure the answer is completely correct? Seems like the contents of the temp table would be within the scope of...

I don’t feel too bad about missing this question for reasons already stated. The take away from this one is to search OBJECT_DEFINITION of sys.procedures to find stored procedures...

Interesting question, thanks. I had no idea you could do this.