2

I did sp_helptext 'sys.sp_columns' and saw that the the underlying table is sys.spt_columns_odbc_view, but I could not execute queries as I get Invalid object name 'sys.spt_columns_odbc_view'.

Is this system table not queryable or am I lacking rights? Not much documentation is provided in msdn.

Antony Thomas
  • 3,576
  • 2
  • 34
  • 40

1 Answers1

1

You should make a DAC connection first, because sys.spt_columns_odbc_view is internal view. After you make DAC, simply query it, like that:

select * from sys.spt_columns_odbc_view

More info on DAC

FrenkyB
  • 6,625
  • 14
  • 67
  • 114