Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Generate Drop / Create Script for views, stored Procedures Expand / Collapse
Author
Message
Posted Saturday, October 20, 2007 10:14 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 6, 2015 3:06 AM
Points: 99, Visits: 125
Comments posted to this topic are about the item Generate Drop / Create Script for views, stored Procedures


Post #413155
Posted Monday, January 14, 2008 5:31 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 8:59 AM
Points: 62, Visits: 57
One can also use this for functions, defaults, rules, and triggers
Post #442778
Posted Thursday, September 23, 2010 1:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 10, 2011 8:48 AM
Points: 7, Visits: 31
The script giving syntax error..please upload again...Thanks..
Post #991777
Posted Tuesday, January 1, 2013 5:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 25, 2016 11:47 AM
Points: 41, Visits: 1,097
Lata Patel (9/23/2010)
The script giving syntax error..please upload again...Thanks..


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.



Post #1401580
Posted Monday, May 2, 2016 4:13 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 26, 2016 7:20 AM
Points: 7,816, Visits: 753
Thanks for the script.
Post #1782742
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse