how to Create stored procedure in SQL management studio using SQL VBO?

[chakravarthy]

HI All, 

I came across the requirement in one of my projects to create stored procedure by executing a query using SQL VBO?

Any suggestions?

Thanks!!

------------------------------
chakravarthy yerrajodu
RPA Developer
Sonata Software Limited
Asia/Kolkata
------------------------------

[ewilson]

Hello @chakravarthy,

Unless I'm mistaken you don't really create stored procedures in SQL Server Management Studio (SSMS) per se. You can use SSMS to create a stored procedure, but the stored procedure is actually created in the database. Does that make sense?

Now, if you wanted to create stored procedures in the database using SSMS, via a VBO, you would need to build the Application Model and UI automation to handle working with the UI of SSMS. Alternatively, you could use the Data - SQL Server VBO ​to execute a CREATE PROCEDURE SQL statement to create a new procedure in the database. You can find more details about CREATE PROCEDURE on SQL Server at the following link:

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql?view=sql-server-ver16

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------