Solved

Visio and reverse engineering of stored procedure

Posted on 2004-04-27
5
2,109 Views
Last Modified: 2012-05-04
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
Comment
Question by:ladylinet
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:kssaran
ID: 10934680
Hi,

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

Rgds
sara
0
 
LVL 7

Author Comment

by:ladylinet
ID: 10941692
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
 
LVL 4

Accepted Solution

by:
kssaran earned 125 total points
ID: 10945430
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
 
LVL 7

Author Comment

by:ladylinet
ID: 10946009
Ok, thanks :( I will look at other packages that you mentioned...

Lady Linet
0
 

Expert Comment

by:anand_dev
ID: 11592075
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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Table where row act as column 11 69
SQL Job Hung 17 37
Split string into 3 separate fields 5 20
UPDATE JOIN multiple tables 5 20
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question