How Can I speed up loading views SMO?

Category: sql server smodmo


vbjunkie on Mon, 20 Mar 2006 22:32:07

Hi there,

I have used all sorts of filters to speed up loading tables,columns using "SetDefaultInitFields".However only the views load very slowly.

If you have an example how you load view could you post it please?

Thanks as usual


vbjunkie on Tue, 21 Mar 2006 09:38:39

Solved by setting the SetDefaultInitFields to type of View and just picking up Name