Changing DB Column Names

[John Smith]

Hey folks,

I've reversed engineered a SQL Server database into Visio.

There are alot of database column names I'd like to change however there are
alot of Stored Procedures that reference the old names. Is there a way to
make Visio update my Stored Procedures whenever I change a database column
name?

Thanks!

 

[Al Edlund]

not being terribly familiar with how stored procedures calls are built
(clueless), I'd start with the question can they be accessed via VBA
externally? AFAIK Visio has no native support for playing with stored
procedure calls.
Al

 

[John Smith]

It does. It's in the Code section. All stored procedures were imported.

 

[Al Edlund]

I don't have any SPs on my SQL box (should, but that's another storey), so I
can't test it. The issue is that some of this modeling is under the covers
and not open to automation, in either case you'd probably have to write some
code to get it done. I'd start by checking to see if it will let you edit
the SP natively (in Visio) and then try to see how they are packaged.
Al