How to find StoredProcedure or trigger

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

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

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