-
Notifications
You must be signed in to change notification settings - Fork 32
Get SqlMessage
mithrandyr edited this page Mar 22, 2018
·
2 revisions
Returns any available informational messages.
Get-SqlMessage returns any informational messages generated by Invoke-SqlScalar, Invoke-SqlQuery, or Invoke-SqlUpdate. Not all providers support informational messages.
In SQL Server, if you use Print or Raiserror without the "NoWait", then messages will be batched to 8kb and then sent. To get messages immediately sent, your query needs to use RAISERROR('your message', 10,1) WITH NOWAIT
.
Mandatory = YES|NO|<default value>
Name | Type | Mandatory | Description |
---|---|---|---|
ConnectionName | String | "default" | User defined name for the connection |