Stored Procedure (sql server 2005) in VISIO Pro 2003

[Sanjeev K Baranwal]

Hi, I am new to VISIO Pro 2003. Please help me that where can I write stored
procedure in Visio?

 

[David Parker]

You cannot create ddl script with Visio Pro.

Hi, I am new to VISIO Pro 2003. Please help me that where can I write
stored
procedure in Visio?

 

[AlEdlund]

Stored procedure calls are "written" in the db management system that you
use. Visio has no native ability to "call" an SPC, it has to be done via
code that somebody develops. The normal v2007 Pro data connect process can
access both Tables/Cubes. The interesting part is that in the connect
process it lists Views as Tables (which obviously infers that you might take
advantage of the underlying query definition for custom data scenarios). If
you're willing to be adventurous you might investigate how the data
connectivity is accomplished using the ODC connect file, which is stored as
XML and editable.
al

 

[Sanjeev K Baranwal]

Dear All,
I know that the forward engineering is not possible in MS Visio Pro 2003.
I am just designign it over there. I dont want forward/reverse engineering.
Please suggest can I use Database->View->Code and write the sps over there?

 

[AlEdlund]

that's not possible, visio does not provide an interface to manipulate a
database interactively .
al

 

[Sanjeev K Baranwal]

I Dont want to make it interactive I will create the design manually. Then is
it possible to write sp's somewhere.

 

[AlEdlund]

Why aren't you using the tools that came with sql server 2005?
al