stored procedures

[vishalgupta]

how can i view the stored procedures defined previously in a given sql database (mdf file)?

[ck9663]

how can i view the stored procedures defined previously in a given sql database (mdf file)?

am not sure what do you mean by "defined previously", but you can view the actual code by doing a sp_helptext mystoredproc in a query analyzer. it will display the entire code UNLESS THE PROGRAMMER EXPLICITLY DEFINED AN ENCRYPTED CODE DURING CREATION OF THE SP.

-- ck

[vishalgupta]

by "defined previously" i mean that ...
a friend of mine has given me a database with some tables and stored procedures
i can use select * to view the tables ....but how do i see the stored procedures defined by him in the database???...g onna try ur command

[ck9663]

by "defined previously" i mean that ...
a friend of mine has given me a database with some tables and stored procedures
i can use select * to view the tables ....but how do i see the stored procedures defined by him in the database???...g onna try ur command

try

select * from sysobjects where xtype = 'P'

it will list all user stored proc. since it will be created by dbo and someone can login as dbo, you can not really tell if he created it....i think....

to view the code, you can still use sp_helptext. unless during creation of stored proc, it was specifically stated that it's encrypted

-- ck