cscg1976
asked on
Error when creating an index / SQL Server 2005
if I execute the following command i get the following error "Msg 1942, Level 16, State 1, Line 1
Cannot create index on view 'ACM2.dbo.vClientList'. It contains text, ntext, image or xml columns."
create unique clustered index vClientListCC on vClientList (ClientName)
if i execute the following command without the one above executed first is giving me the error "Cannot create index on view 'dbo.vClientList'. It does not have a unique clustered index."
CREATE unique INDEX idxCN ON dbo.vClientList(ClientName )
How can i successfully create an index on the view ?
Cannot create index on view 'ACM2.dbo.vClientList'. It contains text, ntext, image or xml columns."
create unique clustered index vClientListCC on vClientList (ClientName)
if i execute the following command without the one above executed first is giving me the error "Cannot create index on view 'dbo.vClientList'. It does not have a unique clustered index."
CREATE unique INDEX idxCN ON dbo.vClientList(ClientName
How can i successfully create an index on the view ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.