• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2223
  • Last Modified:

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
0
ladylinet
Asked:
ladylinet
  • 2
  • 2
1 Solution
 
kssaranCommented:
Hi,

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

Rgds
sara
0
 
ladylinetAuthor Commented:
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
 
0
 
kssaranCommented:
Hi Linet,

As far as my knowledge goes the answer is No. You can try the Trial version provided by Erwin or ER Studio or Toad for that matter.

Rgds
Sara
0
 
ladylinetAuthor Commented:
Ok, thanks :( I will look at other packages that you mentioned...

Lady Linet
0
 
anand_devCommented:
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now