October 30, 2002 at 4:33 am
As DBA I've found that trying to get the programmers to keep effective documentation here is verging on the impossible, so I took control of it, and it's working quite well (if the programmers would take the time to actually READ the stuff I publish on their intranet that is).
My problem is concering the dependencies option in the enterprise manager and the sp_depends stored procedure.
I've noticed that when a stored procedure is created, is registers what tables, etc., it depends upon, but removes the entries indicating what is dependant upon this one!?!?!
Am I going mad? Is there an easy way to maintain this, or is this as useful as an icecube in hell.
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
November 4, 2002 at 8:00 am
This was removed by the editor as SPAM
November 4, 2002 at 11:04 am
Semi useful. If the objects are created in the right order and maintained, it works. Otherwise, it doesn't work.
Steve Jones
November 4, 2002 at 4:12 pm
Yes, another problem is SP with any type of dynamic SQL will not have the dependencies available. However, I do see to recall someone here wrote a script to parse everything in a text sense and make a fairly good representation of the real dependencies (Or maybe I dreamed I was going to do this, sorry I do that sometimes), do check.
November 6, 2002 at 2:19 am
Thanks, I'll check the scripts and see what materialises. In the meantime, I'll just drive the team here crackers with the constant typing until they buy me a quieter keyboard.
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply