https://community.blueprism.com/t5/Product-Forum/how-to-Create-stored-procedure-in-SQL-management-studio-using/m-p/56897#M11002 Hello <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/21400">@chakravarthy</a>,<BR /><BR />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?<BR /><BR />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 <A href="https://digitalexchange.blueprism.com/dx/entry/3439/solution/data---sql-server" target="_blank" rel="noopener">Data - SQL Server</A> 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:<BR /><BR /><A href="https://learn.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql?view=sql-server-ver16" target="_blank" rel="noopener">https://learn.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql?view=sql-server-ver16</A><BR /><BR />Cheers,<BR /><BR />------------------------------<BR />Eric Wilson<BR />Director, Integrations and Enablement<BR />Blue Prism Digital Exchange<BR />------------------------------<BR /> Tue, 13 Dec 2022 18:05:00 GMT ewilson 2022-12-13T18:05:00Z https://community.blueprism.com/t5/Product-Forum/how-to-Create-stored-procedure-in-SQL-management-studio-using/m-p/56896#M11001 HI All,&nbsp;<BR /><BR />I came across the requirement in one of my projects to create stored procedure by executing a query using SQL VBO?<BR /><BR />Any suggestions?<BR /><BR />Thanks!!<BR /><BR />------------------------------<BR />chakravarthy yerrajodu<BR />RPA Developer<BR />Sonata Software Limited<BR />Asia/Kolkata<BR />------------------------------<BR /> Tue, 13 Dec 2022 11:33:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-Create-stored-procedure-in-SQL-management-studio-using/m-p/56896#M11001 chakravarthy 2022-12-13T11:33:00Z https://community.blueprism.com/t5/Product-Forum/how-to-Create-stored-procedure-in-SQL-management-studio-using/m-p/56897#M11002 Hello <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/21400">@chakravarthy</a>,<BR /><BR />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?<BR /><BR />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 <A href="https://digitalexchange.blueprism.com/dx/entry/3439/solution/data---sql-server" target="_blank" rel="noopener">Data - SQL Server</A> 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:<BR /><BR /><A href="https://learn.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql?view=sql-server-ver16" target="_blank" rel="noopener">https://learn.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql?view=sql-server-ver16</A><BR /><BR />Cheers,<BR /><BR />------------------------------<BR />Eric Wilson<BR />Director, Integrations and Enablement<BR />Blue Prism Digital Exchange<BR />------------------------------<BR /> Tue, 13 Dec 2022 18:05:00 GMT https://community.blueprism.com/t5/Product-Forum/how-to-Create-stored-procedure-in-SQL-management-studio-using/m-p/56897#M11002 ewilson 2022-12-13T18:05:00Z