Link to home
Start Free TrialLog in
Avatar of cscg1976
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 ?

ASKER CERTIFIED SOLUTION
Avatar of rboyd56
rboyd56

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial