Re: Dependencies of stored procedures in DTS packages

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

SP_depends is the stored proc I was referring to. Although, I can't filter
the output from it in my code. Is there anyway to see the SQL code for
sp_depends so I can add a where clause to it?

-TIA

Matt

"Matt Williamson" <ih8spam@xxxxxxxxxxx> wrote in message
news:erxr970zFHA.612@xxxxxxxxxxxxxxxxxxxxxxx
>I think sp_sysdepends is giving me exactly what I want.
>
> Thanks
>
> -Matt
>
> "Jacco Schalkwijk" <jacco.please.reply@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
> wrote in message news:upq3vrzzFHA.1624@xxxxxxxxxxxxxxxxxxxxxxx
>> You can get the dependencies between stored procedures, tables and other
>> objects from the sysdepends table.
>>
>> BUT, and this is a big but, the sysdepends table is not always
>> up-to-date, specially if you drop and recreate objects. If you recreate
>> the database from script though (on a development server for example) and
>> make sure that the script doesn't generate any
>> "Cannot add rows to sysdepends for the current stored procedure because
>> it depends on the missing object 'you stored procedure name here'. The
>> stored procedure will still be created."
>> errors, the information in sysdepends will be correct.
>>
>> --
>> Jacco Schalkwijk
>> SQL Server MVP
>>
>>
>> "Matt Williamson" <ih8spam@xxxxxxxxxxx> wrote in message
>> news:%23ajuwWzzFHA.2792@xxxxxxxxxxxxxxxxxxxxxxx
>>> I'm working on a little program to document all of my DTS packages using
>>> the DTS package library and vb6. I have written the code to enumerate
>>> all the DTS packages and step through each one getting the connections
>>> and various steps of the ExecuteSQL and Datapump tasks. I'm trying to
>>> figure out how to get the dependencies of the Stored Procs called from
>>> the ExecuteSQL tasks like in query analyzer. Can anyone point me in the
>>> right direction? I'm working with SQL 2000.
>>>
>>> TIA
>>>
>>> Matt
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: ADO
    ... Does it perhaps not accept scripts, but only single SQL statements? ... call a stored procedure and retreive values from it. ... Get the Stored Proc to run, stand-alone in you MS SQL Editor. ...
    (borland.public.delphi.thirdpartytools.general)
  • Executing a stored procedure that uses linked server from vb.NET
    ... The stored procedure takes the 3 arguments and uses joins to 2 other ... I can run the stored proc on in QA on my MS SQL with no prob. ... Must i open connections to the 2 linked servers from .NET as well? ...
    (microsoft.public.dotnet.languages.vb)
  • I cant step into stored proc for debugging
    ... I cannot step into stored procedure for debugging with VS 2008 with 2005 SQL ... I get this error when I click "Step into stored proc" ...
    (microsoft.public.vsnet.debugging)
  • Re: Views vs Stored Procedures, whats the difference?
    ... I hope you are not suggesting you embed SQL queries into the application? ... A stored procedure logic will be exactly as fast as the algorithm you ... I understant that SQL Server supports hints. ... implementations (nestedloop, merge, hash, ..) on decent sized tables, then ...
    (comp.databases.ms-sqlserver)
  • Re: Stored Procedures - Patterns and Practices
    ... >published the reasoning behind its opinions. ... I disagree that the debate in SQL Server related discussion forums ... If the natural key is long or spans too many ... I want to call a stored procedure that adds a customer ...
    (microsoft.public.sqlserver.programming)