Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to generate script Expand / Collapse
Author
Message
Posted Friday, August 17, 2012 12:34 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 1:43 AM
Points: 71, Visits: 59
Hi ,
Im tryinig to Generate Script for all tables, StoredProcedures ,Functions in a database using Tasks->Generate Scripts->Select Specific Objects->Advance->Drop And create.
Unfortunatley few Functions and a SP is missing.

Kindly let me know if any thing i need to turn on ..
Post #1346349
Posted Friday, August 17, 2012 3:14 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 7:17 AM
Points: 487, Visits: 259
Are you unable to select the functions and the SP or are they missing in the generated script?
Post #1346410
Posted Friday, August 17, 2012 3:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:04 AM
Points: 1,331, Visits: 15,269
Are they encrypted?
Post #1346432
Posted Friday, August 17, 2012 4:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 1:43 AM
Points: 71, Visits: 59
they are missing in the script..
Post #1346456
Posted Friday, August 17, 2012 4:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:04 AM
Points: 1,331, Visits: 15,269
greeshma.patla (8/17/2012)
they are missing in the script..


My point is, encrypted stored procedures (or other objects) will not be scripted.

Post #1346459
Posted Friday, August 17, 2012 4:30 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 1:43 AM
Points: 71, Visits: 59
Functions and SP's whihc are missing in the script are not encrypted one's
Post #1346461
Posted Friday, August 17, 2012 4:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 1:43 AM
Points: 71, Visits: 59
To my surprise ,when I select Functions alone all the functions scipt is generated,Sme is the case with SP's.
But when I Generate Script for entire DB or Select both functions and SP's then few of them are missing..
Please suggest me a solution
Post #1346466
Posted Friday, August 17, 2012 10:11 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:51 PM
Points: 35,606, Visits: 32,190
greeshma.patla (8/17/2012)
To my surprise ,when I select Functions alone all the functions scipt is generated,Sme is the case with SP's.
But when I Generate Script for entire DB or Select both functions and SP's then few of them are missing..
Please suggest me a solution


It sounds like you've correctly identified both the problem and a "solution". Why not just do it that way?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1346804
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse