Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
8022421
Starting Member
45 Posts |
 Posted - 2008-12-19 : 10:40:44
|
| I have created a view with NOLOCK option in the table. when i am trying to create a index it says. "Cannot create index on view 'dev13d1.dbo.viewname' because the view contains a table hint. Consider removing the hint." When I am removed the NOLOCK condition it works fine But I need the index to be created with the Nolock on the view is there a option to create it? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-19 : 11:45:29
|
quote:
Originally posted by 8022421
I have created a view with NOLOCK option in the table. when i am trying to create a index it says. "Cannot create index on view 'dev13d1.dbo.viewname' because the view contains a table hint. Consider removing the hint." When I am removed the NOLOCK condition it works fine But I need the index to be created with the Nolock on the view is there a option to create it?
index views have certain restrictions.You have to follow it. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Creating a Index on a View with NOLOCK option.