master.dbo.spt_values

Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regardsI don't think spt_values is officially documented in any of
Microsoft's documentation. It's mentioned in some articles
and books - you can find some information in this article:
http://www.winnetmag.com/SQLServer/Article/ArticleID/8415/8415.html
and this FAQ post:
http://www.mssqlserver.com/faq/general-sptvalues.asp
It's essentially just a large lookup table used by SQL
Server functions, stored procedures, etc.
-Sue
On Tue, 6 Jul 2004 05:37:05 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:
>Hello,
>Can anybody explain me this table or can send one link
>where i can get this information. This table look likes
>very important but i cant find a good explanation of it.
>Best regards|||This is an undocumented table, for SQL Server's internal use. What is it
that you are after? You can look at the code of system sps that use this
table.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:2739701c46355$f1f742a0$a401280a@.phx.gbl...
Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regards