Home Forums Programming SMO/RMO/DMO smo table script generation performance problem RE: smo table script generation performance problem

  • Hello,

    According http://msdn.microsoft.com/en-us/library/ms210376(v=SQL.100).aspx , i have seen

    "You can use this method to adjust which properties are initialized for an object when it is first created to further optimize performance". I think that SetDefaultInitFields is useful only when we create a new object like Table, StoredProcedure but it is useless to access an existing object like in your case ( you cannot generate a generation script versus an not existing object ).

    I have to do some tests as my last ones were versus SQL Server 2005 .

    Have a nice day