Lynn Pettis (9/18/2012)
SQL Server only allows 1,024 columns per table.
For what it's worth - as of 2008 it's 1024 of non-sparse columns. With sparse columns your column limit per table can be increased to 30,000. See the section on "wide tables" in the BOL entry below.
http://msdn.microsoft.com/en-us/library/ms186986(v=SQL.105).aspx
This still won't help this particular situation unfortunately.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?