Documentation: Finding Database Objects using EM | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Documentation: Finding Database Objects using EM

I have a situation where there are about 400 sps for a database. It has been so much pain everytime to find out a particular SP ( I wish it works for CTL + F, but not) it takes so much time to comb through the whole list. I am sure some of you might have been experiencing this issue…. Following are the ways I tried to make my life simple…but still I am not fully convinced the way it works…. Do you guys have some good ideas or tools/utilties to use, if so please post. 1. I wrote some utility SPs which can find/grep the particualr SP, Table, etc…but when I want to go to the details to see dependencies, etc….it does not work well. 2. I tried online to find out some SQL Seerver Documentation Builder tools/utilities – (How they work is that they simply build a chm file or XML file and then build chm file using NDoc or some other tool). This worked well for most of the time, the pain is that we have to rebuild very freqently in order search the latest. A Trial version which I tried was – AGS SQL Scribe Documentation Builder –http://www.ag-software.com/?tabid=19 Chandra Paladugu
First of all why you’re using EM to accomplish this task, as you can take help of query analyzer by running SP_HELP and other dependancy SPs. Otherwise you can script the stored procedures to a text file and search for required SP. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
quote:Originally posted by satya First of all why you’re using EM to accomplish this task, as you can take help of query analyzer by running SP_HELP and other dependancy SPs. Otherwise you can script the stored procedures to a text file and search for required SP.
I have been doing waht you described, but I am trying to find easiest way rather than hard way of copy to a notepad or wordpad. So do you think it is easy to use SP_HELP rather than EM to see all dependencies, table struct, etc…? Thanks,
Chandra Chandra Paladugu
I wouldn’t go that path when I need to search for any string in database, as EM meant to be flaky at times.
For dependancy objects you can take SP_HELP or sp_depends for more joy. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>