How to find StoredProcedure or trigger

Posted by Winod under Sql Server on 10/27/2012 | Points: 10 | Views : 856 | Status : [Member] | Replies : 3
Hi All,

How to know the storedProcedure or triggers used on a particular table.

thanks .




Responses

Posted by: Mahee87 on: 10/27/2012 [Member] Starter | Points: 25

Up
0
Down
hi,
consider an example
if u are creating one table ie student which contain studentid,student name,address,email.
now create the stored procedure for that table student.
create procedure s1(studentid int)
as
select studentname from student where studentid=@studentid

now exec the procedure

exec s1 100.

i hope u will understand stored procedure for that table

Winod, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Winod on: 10/27/2012 [Member] Starter | Points: 25

Up
0
Down
Hi Mahee87,

when we use sp_depends procedure,we will get the tables used in that perticular stored procedure.Like that if we want to know storedprocrdures or triggers used on any perticular table.

Is there any store Procedure available.

Thanks.

Winod, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sandeepmhatre on: 12/19/2012 [Member] Starter | Points: 25

Up
0
Down
Refer following link

http://sandeepmhatre.blogspot.com/2012/12/stored-procedure-table-name-in-sql.html

Sandeep M,
Software Developer
Follow me on :
http://sandeepmhatre.blogspot.in

Winod, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response