Installing new performance dashboard for SQL Server 2005 SP2

Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||> GUEST wrote
> Hi All
> I tried to install the new performance dashboards on 2005 sp2 o
> windows 2003 and received the following error messages
>
> Has anyone seen these before? I know it is quite new..
>
> Thank
>
> Pete
>
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 2
> 'object_schema_name' is not a recognized built-in function name
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 4
> Incorrect syntax near the keyword 'as'
> Msg 15151, Level 16, State 1, Line
> Cannot find the object 'usp_GetPageDetails', because it does no
exis
> or you do not have permission
I am getting the same error
What is the fix for this if the server is on sp2|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
> > GUEST wrote:
> > Hi All,
> > I tried to install the new performance dashboards on 2005 sp2 on
> > windows 2003 and received the following error messages.
> >
> > Has anyone seen these before? I know it is quite new...
> >
> > Thanks
> >
> > Peter
> >
> >
> > Msg 195, Level 15, State 10, Procedureusp_GetPageDetails, Line 27
> > 'object_schema_name' is not a recognized built-in function name.
> > Msg 156, Level 15, State 1, Procedureusp_GetPageDetails, Line 42
> > Incorrect syntax near the keyword 'as'.
> > Msg 15151, Level 16, State 1, Line 1
> > Cannot find the object 'usp_GetPageDetails', because it does not
> exist
> > or you do not have permission.
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?