How to import Stored procedure in Visio

Question

Is it possible to add Stored procedure and sqlagent jobs in ER diagram using Visio when reverse engineering? ER diagram has the tables and relationships but Stored procedures and SqlServer agent jobs are not represented in ER diagram.

Answer 1

Hi,

Your question is more related to Microsoft Visio diagramming tool, than to SQL Server.

Microsoft Visio allows to present table structured entities like Tables or Views, but Stored Procedure and job has nothing to do with such information. These entities does not have any structure and can include multiple statements. A stored procedures is used to group one or more Transact-SQL statements into logical units. What exactly do you want to present in such case?

A JOB or SP not always have any data which is returned for example but other tasks. SP can returns multiple set of data and not only a single set, so what do you want to present at VISIO?

The answer is that your request does not make sense. Microsoft Visio is a diagramming and vector graphics application and it can present such data with structure.