What I meant to say is

For example you have a Stored Procedure GetUsers and
you want to execute some other stored
procedure,GetEmployeesInfo , which u need inside
GetUsers

Then inside Getusers stored procedure you write a
command like
Exec GetEmployeeInfo.

I hope thats what you wanted.



--- Bill Conner <bill.[Email Address Removed] wrote:
> It says "could not find stored procedure
> 'ScriptName' " and aborts out of
> the main script.
>
> At 11:12 AM 5/23/2002 -0700, Parag Kulkarni wrote:
> >Yes you can do it by the syntax below
> >
> >Exec ScriptName
> >
> >
> >
> >
> >
> >--- Bill Conner <bill.[Email Address Removed] wrote:
> > > Hi All,
> > >
> > > Is there any way to execute a sql script from
> inside
> > > of sql script?
> > >
> > > Thanks,
> > >
> > > -bill
> > >
> > >
> > >
> > >
>
>---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > > mssqldba-[Email Address Removed] > > For additional commands, e-mail:
> > > mssqldba-[Email Address Removed] > >
> >
> >
> >__________________________________________________
> >Do You Yahoo!?
> >LAUNCH - Your Yahoo! Music Experience
> >http://launch.yahoo.com
> >
>
>---------------------------------------------------------------------
> >To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] >For additional commands, e-mail:
> mssqldba-[Email Address Removed]
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
MS Sql Server LazyDBA home page