in SQL SERVER 2008
Q 1.How many maximum column can be in a table in sql server 2008?
Ans: Max row size is 8,060 bytes so its depends on column type in a table.
Q 2. How many maximum foreign key table reference per table?
Ans : 253
Q.3 How many maximum nested sub quires/store procedure /triggers ?
Ans: 32
Q.4 How many maximum parameters in user function / store procedure?
Ans : 2100
Q.5 How many maximum number of columns in per SELECT/INSERT/UPDATE statement?
Ans : 4096
Q.6 How many rows in table in SQl Server 2008?
http://stackoverflow.com/questions/759244/sql-server-the-maximum-number-of-rows-in-table[
^]