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@.TK2MSFTNG
P12.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...[vbcol=seagreen]
> 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