NOEXPAND and WITH SCHEMABINDING

Note to self. If I see another error involving NOEXPAND check these

1) Make sure server is running SQL 2005
2) Make sure the view has WITH SCHEMABINDING in the DDL (i.e. I need to check my upgrade scripts, … in reverse order)

About this entry

You’re currently reading “ NOEXPAND and WITH SCHEMABINDING ,” an entry on Chui's Counterpoint

Published:
4.24.09 / 5pm
Category:
General