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 regards
I 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/A...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