Archives for posts tagged ‘mssql’

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)