Link to home
Start Free TrialLog in
Avatar of ladylinet
ladylinet

asked on

Visio and reverse engineering of stored procedure

Hi,
 I'm using SQL Server 2000, and I want to get all tables that I've used in stored procedure on database diagram. Only thing I've got so far is code.
 Is it possible at all? What is the purpose of reverse engineer stored procedure???

Thanks.
Lady Linet
Avatar of kssaran
kssaran

Hi,

I dont know if you have used ERWIN DB Modelling Tool. That will get you all u needed.

Rgds
sara
Avatar of ladylinet

ASKER

Hi, thanks, I will look at Erwin if we get a copy.
 In the meantime, do you know is Visio capable of reverse engineering tables from stored procedures or I'm asking too much?

Thanks.
Lady Linet
 
ASKER CERTIFIED SOLUTION
Avatar of kssaran
kssaran

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ok, thanks :( I will look at other packages that you mentioned...

Lady Linet
did you find a solution for you problem. I have about 240 stored procedures
and a nightmare at hand. which I ahve to link to tables and modify them.