Can anyone tell me about MSSCONCATCOL

[joelm]

Can someone tell me more about MSSCONCATCOL?? Why it appears on certain tables and do not on most??
Early on, I was having a problem with running DBCC REINDEX on a table
and I was able to trace it to the settings I specified when I initially created a Peoplesoft database (ie.'ANSI_NULLS','QUOTED_IDENTIFIER') and because this table contained the column, MSSCONCATCOL.
I simply dropped this column and the reindexing worked.
Any information shared will be greatly appreciated.
Thank you

[JBane]

I've never heard of such a column. Is it specific to the PeopleSoft db or are you finding it in other dbs?

Jeff

[joelm]

Hi Jeff -

Am not sure if MSSCONCATCOL is specific to Peoplesoft DB. All I know is when I initially created the DB from the Peoplesoft delivered SYS tables, it was there. Thanks for your reply though.

[rmiao]

Should check with PeopleSoft.

[john_b]

To get around a limit of 16 columns in an index, PeopleSoft generates an additional column (function based) to a table with more than 16 keys. The key data is contatenated in this column, and the primary index will only contain the field MSSCONCATCOL. It is the Microsoft SQL Server Concatenated Column (storing all primary key data).