Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-15 : 07:39:38
|
| Tim writes "I've read some encouraging articles on this, and some not so encouraging articles :) I'm using SQL Server 2000, and have written some fairly complex stored procedures that create dynamic sql for pivot tables, etc... I print messages throughout the sprocs creating a sort of log by time. Whenever one of these sprocs is run, it is also logged to a history table with inputs, but I would also like to get some of the output. Is it possible at the end of the stored procedure to capture the Messages output, and write it a text field in my history table?? The dynamic sql being created is over 8000 chars, so concatenating varchars is out... I know of a way I could use a temp table with a few text fields to concatenate, but thought there must be an easier way. Any information would be greatly appreciated!Thank you,Tim" |
|
|
|
|
|
SQL Server Messages