• Hi Lowell

    You are correct.If i select in options then it works.

    But there is an exception.If i am using "script entire database and all database objects" while generating script then all objects are created irrespective of the setting in tools-> options. I think it is because as option says "script entire database and all database objects".