I don't think that using views will get round the 16-table limit, since it counts all individual references to tables within the statement, whether directly or as part of a view.<BR><BR>As an ...

Does anyone know if SQL 2k Std suffers a hard limit on the size of a db can be, just like Exchange 2000/2003 has?

You don't need an expertise in SQL to limit the number of records in a group. With your user knowledge of queries and reports, you have all the expertise you need.

Microsoft is making a series of enhancements to its Azure SQL Database, including a new "Premium RS" tier, as the big public cloud providers roll out new ...