Stored Procedure in SQL Server 2000 ?

3 May 2006 6:39 AM

ss

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

3 May 2006 12:23 PM

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!
*************************************************

Show quote

"ss" <s*@discussions.microsoft.com> wrote in message
news:F6E479C1-EB05-4274-B5F9-896175281A02@microsoft.com...
> 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