To get the list of all Stored procedures written by user for its database operation, following query is useful. select * from [myDataBaseName].sys.procedures where is_ms_shipped = 0 order by name
"..........way of sharing knowledge."
"..........way of sharing knowledge."