Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is [sys].[sp_columns_100_rowset] used for?

Status
Not open for further replies.

HoustonGuy

Programmer
Jun 29, 2000
165
US
It appears [sys].[sp_columns_100_rowset] simply returns schema data for a DB, or table. I see it being called in a trace I have on a DB, but I'm not sure why a process would use this system SP.
It's being called via RPC by VS2013 application. (Either manually, or automated - I can't tell.)

Any thoughts?

Thanks in advance. :)
 
It's typically used by applications that employ server-side cursors to process the data.

-----------
With business clients like mine, you'd be better off herding cats.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top