Stored Procedure in SQL Server 2000 ?

[Guest]

Hi,

How do I get the all possible stored procedures for a given table in SQL
Server 2000 for example like
To Insert,
To Insert with Parameters,
To Update,
To Delete,
To Do Transaction ie for example to Transfer Some Amount from One Account to
Another Account. I should be able to pass the Account A, Account B and the
Amount to be Transfer.

Thanks & Regards,
SS

 

[Cowboy \(Gregory A. Beamer\)]

You can find all sprocs that depend on a specific table (provided you do not
have circular dependencies). At worst case, it is in the sysdepends table.
What they do is a bit more problematic, as you have to actually examine the
code in the syscomments table and determine what type of CRUD is done. What
determines this is very company specific, so you will have to create the
business rules.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************