SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by doktor-kermit / Generate Drop / Create Script for views, stored Procedures / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 23:00:16 GMT20RE: Generate Drop / Create Script for views, stored Procedureshttp://www.sqlservercentral.com/Forums/Topic413155-1012-1.aspx[quote][b]Lata Patel (9/23/2010)[/b][hr]The script giving syntax error..please upload again...Thanks..[/quote]Just do a find/replace with the characters holding the indentation formatting. I replaced w/ a space and worked fine.Thanks for a cool use of the system tables.Tue, 01 Jan 2013 05:18:13 GMTtskelleyRE: Generate Drop / Create Script for views, stored Procedureshttp://www.sqlservercentral.com/Forums/Topic413155-1012-1.aspxThe script giving syntax error..please upload again...Thanks..Thu, 23 Sep 2010 01:40:23 GMTLata PatelRE: Generate Drop / Create Script for views, stored Procedureshttp://www.sqlservercentral.com/Forums/Topic413155-1012-1.aspxOne can also use this for functions, defaults, rules, and triggersMon, 14 Jan 2008 17:31:28 GMTWyatt WingheadGenerate Drop / Create Script for views, stored Procedureshttp://www.sqlservercentral.com/Forums/Topic413155-1012-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Maintenance+and+Management/61340/">Generate Drop / Create Script for views, stored Procedures</A>[/B]Sat, 20 Oct 2007 22:14:24 GMTdoktor-kermit