When you build query plans for SELECT statements, the query optimizer avoids nonclustered indexes and indexed views that reside in offline filegroups. This enables these statements to succeed. However ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results