In general, if you run a SQL statement in SSMS and get messages back (e.g. "x rows updated") you should be able to retrieve that via SQLGetMessage.

Sometimes you can get multiple result sets, and each result set may have it's own set of messages. So in that situation you may need to use SQLNextResultSet to retrieve the next result set (even if there are no columns returned) and get the messages for that result set.