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???...gonna 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