"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:OxxAHm8CFHA.3812@TK2MSFTNGP15.phx.gbl...
> They're not?
>
> They should be AFAIK
>
> Whilst only a sysadmin can execute them you should be able to see them
>
>
>
> "Darbs" <m_darbyshire@hotmail.com> wrote in message
> news:m_darbyshire@hotmail.com:
>> Thanks Allan,
>>
>> That looks like it will do the job although 1 minor issue:- stored procs
>>
>> sp_OACreate, sp_OAMethod and sp_OADestroy are not in master on my server
>>
>> (SQL2000 sp4 enterprise) - is there a script somewhere that I can use to
>>
>> create them???
>>
>> Thanks,
>>
>> Mark.
>>
>>
>> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
>> news:O3BiHx7CFHA.1564@TK2MSFTNGP09.phx.gbl...
>> > Does this help
>> >
>> > http://www.sqldts.com/default.aspx?219
>> >
>> >
>> >
>> > "Darbs" <m_darbyshire@hotmail.com> wrote in message
>> > news:m_darbyshire@hotmail.com:
>> >> All,
>> >>
>> >> I've written a DTS package that contains a complex VBScript that all
>> >> works
>> >>
>> >> fine but the problem is that I dont know how to fire this DTS package
>> >>
>> >> from
>> >>
>> >> an INSERT trigger on a table (I specifically want to avoid a scheduled
>> >>
>> >> DTS
>> >>
>> >> job in this case for performance).
>> >>
>> >> I suppose the alternative would be to get the trigger to fire a
>> >> stored
>> >> proc
>> >> but then how can I execute a VBScript from a stored proc?
>> >>
>> >> Any help (or alternative method if I'm barking up the wrong tree)
>> >> would
>> >>
>> >> be
>> >>
>> >> greatly appreciated.
>> >>
>> >> Thanks,
>> >>
>> >> Darbs....
>> >
>