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)

You should follow me on twitter here

Comments are closed.