"None can stop the rising sun, clouds can hide for a while........" -Ravi

Thursday, August 20, 2009

Ceating Indexes on views in SQL 2005

When I was creating Index on view, I got the following error.
"Cannot create index on view 'v_testview' because the view is not schema bound. (Microsoft SQL Server, Error: 1939)". Following link helped me to figure out the solution.

http://www.mssqltips.com/tip.asp?tip=1610

It may hellpfull to you also..

No comments: