Hi,
One of our team has come across the following message, I can't find
reference
to it anywhere, any suggestions?:
"Server: Msg 1936, Level 16, State 1, Line 1
Cannot index the view 'Albert_Heijn_LOAD.dbo.v_Supplier'. It contains one or
more disallowed constructs."Seems like you try to create an index on a view, where the view contain some construct which is
disallowed, quite simply.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Stressed" <k@.c.co.uk> wrote in message news:OMJgF0wlDHA.1740@.TK2MSFTNGP12.phx.gbl...
> Hi,
> One of our team has come across the following message, I can't find
> reference
> to it anywhere, any suggestions?:
> "Server: Msg 1936, Level 16, State 1, Line 1
> Cannot index the view 'Albert_Heijn_LOAD.dbo.v_Supplier'. It contains one or
> more disallowed constructs."
>|||I'd gathered that something was not allowed, just that there was no further
reference to it in BOL or on the web.
Turns out that the user was trying to use a computed column, which was
non-deterministic.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:OwMDw4wlDHA.2068@.TK2MSFTNGP09.phx.gbl...
> Seems like you try to create an index on a view, where the view contain
some construct which is
> disallowed, quite simply.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Stressed" <k@.c.co.uk> wrote in message
news:OMJgF0wlDHA.1740@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > One of our team has come across the following message, I can't find
> > reference
> >
> > to it anywhere, any suggestions?:
> >
> > "Server: Msg 1936, Level 16, State 1, Line 1
> >
> > Cannot index the view 'Albert_Heijn_LOAD.dbo.v_Supplier'. It contains
one or
> > more disallowed constructs."
> >
> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment