Help! Crunch time here

I use OpenXML() to bulk load data into a table from C# 2003. It works
beautifully until yesterday. In order to run this successfully and
work with Parent to Child relationships, I add a column on each bulk
load called XmlId type Int.
Anyway, so now I have an error that states:
Msg 1714, Level 16, State 1, Line 1
Alter table failed because unique column IDs have been exhausted for
table 'promotionhistory'.
I only have 17 million records in the table and besides, I'm not adding
a new row..just a column.
So now this alter table statement fails:
alter table PromotionHistory add xmlId int
Someone please help!nnelson wrote:
> I use OpenXML() to bulk load data into a table from C# 2003. It works
> beautifully until yesterday. In order to run this successfully and
> work with Parent to Child relationships, I add a column on each bulk
> load called XmlId type Int.
> Anyway, so now I have an error that states:
> Msg 1714, Level 16, State 1, Line 1
> Alter table failed because unique column IDs have been exhausted for
> table 'promotionhistory'.
> I only have 17 million records in the table and besides, I'm not adding
> a new row..just a column.
> So now this alter table statement fails:
> alter table PromotionHistory add xmlId int
> Someone please help!
>
How many columns are in the table? You may have reached the SQL Server maximum.
Run this:
select max(b.colid)
from sysobjects as a
join syscolumns as b on a.id = b.id
where a.[name] = N'promotionhistory'
This will give you the maximum column ID on the table.

Help! Crunch time here

I use OpenXML() to bulk load data into a table from C# 2003. It works
beautifully until yesterday. In order to run this successfully and
work with Parent to Child relationships, I add a column on each bulk
load called XmlId type Int.
Anyway, so now I have an error that states:
Msg 1714, Level 16, State 1, Line 1
Alter table failed because unique column IDs have been exhausted for
table 'promotionhistory'.
I only have 17 million records in the table and besides, I'm not adding
a new row..just a column.
So now this alter table statement fails:
alter table PromotionHistory add xmlId int
Someone please help!nnelson wrote:
> I use OpenXML() to bulk load data into a table from C# 2003. It works
> beautifully until yesterday. In order to run this successfully and
> work with Parent to Child relationships, I add a column on each bulk
> load called XmlId type Int.
> Anyway, so now I have an error that states:
> Msg 1714, Level 16, State 1, Line 1
> Alter table failed because unique column IDs have been exhausted for
> table 'promotionhistory'.
> I only have 17 million records in the table and besides, I'm not adding
> a new row..just a column.
> So now this alter table statement fails:
> alter table PromotionHistory add xmlId int
> Someone please help!
>
How many columns are in the table? You may have reached the SQL Server maxi
mum.
Run this:
select max(b.colid)
from sysobjects as a
join syscolumns as b on a.id = b.id
where a.[name] = N'promotionhistory'
This will give you the maximum column ID on the table.