[dba-SQLServer] A2007 + SQL 2005

artful at rogers.com artful at rogers.com
Wed Jan 3 11:46:54 CST 2007


My experience thus far with A2007 is quite limited. I have a few questions:

1. One of the really advances in SQL 2005 is its revised notion of schemas. This can be seen in the AdventureWorks sample db. Schemas allow you to divide the tables in a database into logical groups. The table is thus named:

MySchema.MyTable

Does A2007 support this?

2. What about the various forms of UDFs (scalar, table-valued, etc.)? Are they all supported?

TIA,
Arthur





More information about the dba-SQLServer mailing list