Indexed Views Sql Server 2008. The objectproperty and objectpropertyex system meta data functions return similar results and they both can be used to get the information about schema scoped. I cannot have any down time.

Views are logical objects in sql server databases that present you with a “virtual table”. The page on creating indexed views lists a number of restrictions: Jonathan kehayias | principal consultant, sqlskills.com sql server mvp | microsoft certified master: