Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Creating stored procedures from with an applicatio

Author  Topic  BB4 Starting Member 1 Post Posted - 2013-03-14 : 02:40:24 Is it possible to create stored procedures from within an application? I maintain an established application, developed in PowerBuilder 11.2 and connected to a MS SQL Server 2005 database. I am about to use stored procedures to ramp up the speed of several functions within the application. By way of analogy, the dynamics of the application require frequent database modifications, and I effect those database changes programatically from within the application for each new release. This then does not require the client DBAs to make the changes on site to their databases. If I resort to several stored procedures, it would be immensely practical if I could code the creation of the SPs from within the PowerBuilder application.