About sys.fn_indexinfo in SQL2005 MOC 2733A

Hi guys,
i reading the MOC 2733A for SQL2005 and found the "sys.fn_indexinfo"
function in a module 5 but when i run a sys.fn_indexinfo how indicated a
error showed
Seems that not exist ... it's possible ? It was replaced ?
If so how i can view a index defrag status ?
Thanks in advance.You might have an version of the course that was based on a beta of the prod
uct. My guess is that
the function you want is sys.dm_db_index_physical_stats.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<io.com@.newsgroup.nospam> wrote in message news:O6mSA$DzGHA.3908@.TK2MSFTNGP05.phx.gbl...[vbc
ol=seagreen]
> Hi guys,
> i reading the MOC 2733A for SQL2005 and found the "sys.fn_indexinfo" funct
ion in a module 5 but
> when i run a sys.fn_indexinfo how indicated a error showed
> Seems that not exist ... it's possible ? It was replaced ?
> If so how i can view a index defrag status ?
> Thanks in advance.
>[/vbcol]|||Yes it's right.
Found!
bye.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGPTSCEzGHA.4972@.TK2MSFTNGP03.phx.gbl...
> You might have an version of the course that was based on a beta of the
> product. My guess is that the function you want is
> sys.dm_db_index_physical_stats.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> <io.com@.newsgroup.nospam> wrote in message
> news:O6mSA$DzGHA.3908@.TK2MSFTNGP05.phx.gbl...
>|||Hi IO,
So far as I know, number of information in MOC 2733 is changed since it is
based on SQL 2005 beta. If you have any other questions, feel free to post
in our newsgroup. We are glad to provide assistance.
Have a good day!
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
<uGPTSCEzGHA.4972@.TK2MSFTNGP03.phx.gbl>[vbcol=seagreen]
in[vbcol=seagreen]
a[vbcol=seagreen]