Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

sp_columns does not return NVARCHAR data type columns

5 views
Skip to first unread message

Nils

unread,
Dec 23, 2009, 6:35:01 AM12/23/09
to
Hi,

our SQL Server Version is 2000 SP4.

For several days the SP "sp_columns" does not return NVARCHAR data type
columns any more.

I reviewd the SP "sp_columns" and it seems, that the used SP
"spt_datatype_info" does not return that type any more. A second production
server returns that column type.

The SP "sp_columns" is used by the ODBC-Driver to determine the table columns.

Any suggestions?

Thanks a lot,
Nils

Nils

unread,
Dec 23, 2009, 6:52:01 AM12/23/09
to
Ok, my fault,

it seems that "spt_datatype_info" is a table and there is no NVARCHAR row.

After inserting that row, everything works as expected.

Strange... but problem solved

0 new messages