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 |
|
whiterabbot
Starting Member
18 Posts |
 Posted - 2008-12-17 : 17:47:20
|
| I am creating a view using schemabinding so I can create an index but I get that it does not recognize this function. From the article that I read it said that SqlServer 2000 has this ability. Is there something that I am missing?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-17 : 17:51:18
|
| Are you running SQL 2000 Enterprise Edition? It supports only ENt Edition. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-17 : 17:52:52
|
| Also see this for limitation:http://www.sqlteam.com/article/indexed-views-in-sql-server-2000 |
|
|
|
whiterabbot
Starting Member
18 Posts |
Posted - 2008-12-17 : 17:56:50
|
| I am running SQL 2000 Enterprise Edition. So I guess I will have to try something else. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-17 : 17:59:30
|
| Did you see the link? It works only in Enterprise edition . |
|
|
|
whiterabbot
Starting Member
18 Posts |
Posted - 2008-12-17 : 18:02:07
|
| I just realized that after I sent that message. Looking at article now. Thanks |
|
|
|
|
|
|
Schemabinding