Capture SQL Messages

[dm_14]

How do capture SQL Messages ?

lets say I have a SQL stored procedure that use print statements. In query
analyser the results of the print statements they would appear in the message
tab. How can I capture these messages in a Power shell script ?

Thanks

[Marco Shaw]

I was trying to show you a practical example using SMO, but cannot seem
to figure out how to run a stored procedure from it.

Normally, you're information will go directly to the console, but you
need to script that stored procedure to be run by a PowerShell script.

I can't explain it better than that right now.

What version of SQL? I think SMO is only supported with 2005, so that
might not even be an option.

Marco

[Crito]

Use the sqlcmd utility with SQL Server 2005 or use isql (or osql if you
prefer) with previous versions.
'sqlcmd Utility'
(http://msdn2.microsoft.com/en-us/library/ms162773.aspx)
'isql Utility'
(http://msdn2.microsoft.com/en-us/library/aa214007(SQL.80).aspx)
'Running the osql Utility'
(http://msdn2.microsoft.com/en-us/library/aa213088(SQL.80).aspx)

--
Crito

[RichS]

SMO is for management of SQL Server not data access

To run the stored proc you need to use ADO.NET. You could return the
information as output parameters. I'll put an example on my blog
--
Richard Siddaway
Please note that all scripts are supplied "as is" and with no warranty
Blog: http://richardsiddaway.spaces.live.com/
PowerShell User Group: http://www.get-psuguk.org.uk

[Crito]

sqlcmd, isql and osql are the command line equivalents of query
analyzer. you'd use the exact same commands and you'd receive the exact
same results.

--
Crito