Comments
Sort by recent activity
Sorry for this, you are right: filtered indexes have been added since 2008 server.
Probably, you should close the bug. / comments
Sorry for this, you are right: filtered indexes have been added since 2008 server.
Probably, you should close the bug.
Hello Brian!
I reproduced it today on databases located on this env.:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
You are right, the problem is about compatibility levels.
I used value of "90" (2005) for "source" DB and value of "100" for "target" DB.
Both levels support filtered indexes.
The script to create "source":
create table TBL
(
col1 int null
)
create index IX1_TBL on TBL (col1) where col1 = 0
The script to create "target" (the column is not null):
create table TBL
(
col1 int not null
)
create index IX1_TBL on TBL (col1) where col1 = 0
/ comments
Hello Brian!
I reproduced it today on databases located on this env.:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Develope...