Number of coloums in table

is there a limit in number of coloumns in a table?

is there a size limit of a row?I think its a couple of thousand columns per table.|||

Yes, and yes. And the amounts depend on which version of SQL Server you are running.

2000 has a row size limit of 8060-ish (it's close to that if not exactly that), that doesn't include blob data (image/text). And there can only be 1024 columns per table.

The same applies for 2005, however, it gets a bit trickier to actually hit that limit since any variable length field (varchar/varbinary,nvarchar, etc) can be reduced to a 24-byte pointer node if that particular row is too large. So if a particular row's data would exceed 8060 bytes, it starts reducing the variable length fields to 24-byte nodes until the row will fit within the 8060 byte limit, and place the actual field data in out of row storage for you behind the scenes.