• I don't fully understand your description, but it seems that you check Tools->Options->SQL Server Object Explorer->Scripting and that the option "Generate script for dependent objects" is set to False.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]