topic RE: Get Messages from SQL database server to Blueprism in Product Forum https://community.blueprism.com/t5/Product-Forum/Get-Messages-from-SQL-database-server-to-Blueprism/m-p/51047#M6178 Hi RPA Guy ​I am trying to create a robot there is checking sql server and database to see if everything is ok.<BR />Sending a check to see if Blueprism database is ok<BR /><BR />Example dbcc checkdb<BR /><BR />then you will get the answer in sql server page messages&nbsp;<BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="25878.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/26010i01393F0EA07D4271/image-size/large?v=v2&amp;px=999" role="button" title="25878.png" alt="25878.png" /></span></DIV> I have no access to the sql database and it would be nice to confirm database is ok before running the robots.<BR /><BR />------------------------------<BR />Kristian Holm<BR />RPA programmer<BR />PenSam (Pension Company)<BR />Copenhagen Denmark<BR />------------------------------<BR /> Mon, 07 Dec 2020 08:13:00 GMT KristianHolm1 2020-12-07T08:13:00Z Get Messages from SQL database server to Blueprism https://community.blueprism.com/t5/Product-Forum/Get-Messages-from-SQL-database-server-to-Blueprism/m-p/51044#M6175 ​Hi Blueprism team<BR /><BR />Can you get Messages from the sql server you are connected to after running a sql script to Blueprism using VBA script.?<BR /><BR />se attached file for more information.<BR /><BR />------------------------------<BR />Kristian Holm<BR />RPA programmer<BR />PenSam (Pension Company)<BR />Copenhagen Denmark<BR />------------------------------<BR /> Fri, 04 Dec 2020 13:49:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Messages-from-SQL-database-server-to-Blueprism/m-p/51044#M6175 KristianHolm1 2020-12-04T13:49:00Z RE: Get Messages from SQL database server to Blueprism https://community.blueprism.com/t5/Product-Forum/Get-Messages-from-SQL-database-server-to-Blueprism/m-p/51045#M6176 What are you looking to achieve by getting those messages? Usually it just says the number of rows affected, which you can calculate yourself. If it's a SELECT statement, then you can count the # of rows returned. If it's an UPDATE statement, you can just run a SELECT statement before hand with the same WHERE clause or w/e in order to determine how many rows will be affected and then run the UPDATE. In any case, I feel like those are SSMS-specific messages that it separately calculates. When you execute a SQL Server query, I imagine SSMS messages wouldn't be involved at all.​<BR /><BR />------------------------------<BR />Dave Morris<BR />Cano Ai<BR />Atlanta, GA<BR />------------------------------<BR /> Fri, 04 Dec 2020 15:57:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Messages-from-SQL-database-server-to-Blueprism/m-p/51045#M6176 david.l.morris 2020-12-04T15:57:00Z RE: Get Messages from SQL database server to Blueprism https://community.blueprism.com/t5/Product-Forum/Get-Messages-from-SQL-database-server-to-Blueprism/m-p/51046#M6177 To add to Dave's answer, there should be a Get Records Affected page within the Data - SQL Server object that will execute a statement and return the number rows it affected.<BR /><BR />------------------------------<BR />Nicholas Zejdlik<BR />RPA Developer<BR />------------------------------<BR /> Fri, 04 Dec 2020 21:26:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Messages-from-SQL-database-server-to-Blueprism/m-p/51046#M6177 NicholasZejdlik 2020-12-04T21:26:00Z RE: Get Messages from SQL database server to Blueprism https://community.blueprism.com/t5/Product-Forum/Get-Messages-from-SQL-database-server-to-Blueprism/m-p/51047#M6178 Hi RPA Guy ​I am trying to create a robot there is checking sql server and database to see if everything is ok.<BR />Sending a check to see if Blueprism database is ok<BR /><BR />Example dbcc checkdb<BR /><BR />then you will get the answer in sql server page messages&nbsp;<BR /> <DIV class="media" style="overflow: hidden; zoom: 1;"><span class="lia-inline-image-display-wrapper" image-alt="25878.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/26010i01393F0EA07D4271/image-size/large?v=v2&amp;px=999" role="button" title="25878.png" alt="25878.png" /></span></DIV> I have no access to the sql database and it would be nice to confirm database is ok before running the robots.<BR /><BR />------------------------------<BR />Kristian Holm<BR />RPA programmer<BR />PenSam (Pension Company)<BR />Copenhagen Denmark<BR />------------------------------<BR /> Mon, 07 Dec 2020 08:13:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Messages-from-SQL-database-server-to-Blueprism/m-p/51047#M6178 KristianHolm1 2020-12-07T08:13:00Z