Generate SQL Script.

Hello, Folks
Problem in SQL EM , I can't generate sql script for selected tables with
depended objects.
Any ideas ?

Jonh Smith  wrote:
> Hello, Folks
> Problem in SQL EM , I can't generate sql script for selected tables
> with depended objects.
> Any ideas ?

Could you let us know what's happening when you try to generate the DDL?

--
David G.

David,
It is only show me selected table(s) no depended.

"David Gugick" <davidg-nospam@imceda.com> wrote in message news:%23j85MDBTFHA.2556@TK2MSFTN
GP12.phx.gbl...
> Jonh Smith wrote: 
> 
> Could you let us know what's happening when you try to generate the DDL?
> 
> -- 
> David G.
> 
>

I'm not sure how these objects you are extracting are related or how SQL
EM implements dependant object extraction. It may use sp_depends to
figure it out. If you run sp_depends on the objects you are extracting,
do you see the dependant objects listed?

--
David Gugick
Imceda Software
www.imceda.com

"Jonh Smith" <snapplefor@hotmail.com> wrote in message
news:%23j00$GBTFHA.2124@TK2MSFTNGP14.phx.gbl...
David,
It is only show me selected table(s) no depended.

"David Gugick" <davidg-nospam@imceda.com> wrote in message
news:%23j85MDBTFHA.2556@TK2MSFTNGP12.phx.gbl...
> Jonh Smith wrote: 
>
> Could you let us know what's happening when you try to generate the
> DDL?
>
> --
> David G.
>
>

In EM "Display all dependant" working fine,sp_depends  working too
But what happen with Script Generator ? it don't generate for me dependant
objects.
Did you try your EM on this case ?




"David Gugick" <davidg-nospam@imceda.com> wrote in message
news:%23IlOeNBTFHA.3620@TK2MSFTNGP09.phx.gbl...
> I'm not sure how these objects you are extracting are related or how SQL
> EM implements dependant object extraction. It may use sp_depends to figure
> it out. If you run sp_depends on the objects you are extracting, do you
> see the dependant objects listed?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
> "Jonh Smith" <snapplefor@hotmail.com> wrote in message
> news:%23j00$GBTFHA.2124@TK2MSFTNGP14.phx.gbl...
> David,
> It is only show me selected table(s) no depended.
>
> "David Gugick" <davidg-nospam@imceda.com> wrote in message
> news:%23j85MDBTFHA.2556@TK2MSFTNGP12.phx.gbl... 

Jonh Smith  wrote:
> In EM "Display all dependant" working fine,sp_depends  working too
> But what happen with Script Generator ? it don't generate for me
> dependant objects.
> Did you try your EM on this case ?
>

I've used it in the past successfully. If I export the "titleauthor"
table from pubs and select the option to export dependant objects, it
works for me.

--
David Gugick
Imceda Software
www.imceda.com

David, you are right it is working for "pubs", but for different db is not.

What is a problem? What do you think?





"David Gugick" <davidg-nospam@imceda.com> wrote in message
news:O69APYCTFHA.3936@TK2MSFTNGP15.phx.gbl...
> Jonh Smith wrote: 
>
> I've used it in the past successfully. If I export the "titleauthor" table
> from pubs and select the option to export dependant objects, it works for
> me.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com

Jonh Smith  wrote:
> David, you are right it is working for "pubs", but for different db
> is not.
>
> What is a problem? What do you think?
>

I have no idea, unfortunately. Sorry.

--
David Gugick
Imceda Software
www.imceda.com

Thank you David for your response.



"David Gugick" <davidg-nospam@imceda.com> wrote in message
news:eq2tq4CTFHA.2304@tk2msftngp13.phx.gbl...
> Jonh Smith wrote: 
>
> I have no idea, unfortunately. Sorry.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com