I believe that the key is the number of sockets on the motherboard, not the number of processing cores. Someone please correct me if I'm wrong, but I believe...

There is a good first place to look at MSDN. I haven't figured out how to make the link live.... ;o(

http://msdn2.microsoft.com/en-us/library/ms179316.aspx

Definitely worth a search for...

There isn't a table limit per se, but there is a limit to the number of objects (tables, views, stored procedures, UDFs, triggers, rules, detaults, & constraints) that can exist...

I found that when I installed SQL Server 2005 for what I thought was the first time on a server that my network admin had installed backup software that had...