RE: Unable to generate script

SSC Guru

Points: 1003853

August 17, 2012 at 10:11 pm

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)