how to capture print statements from proc?

hi!

i make job executes stored procedures return stuff message tab.

the content of message tab should sent email (or captured in table).

i assume must possbile writing clr proc, how?

in actual case want capture output 3. party (sourceforge) unit test stored procedure, deliveres report in message tab.

thanks

bjorn

---

b. d. jensen

sure bjorn,

there example of using connection events (albeit oledbconnection, need use sqlconnection) here: http://msdn.microsoft.com/en-us/library/a0hee08w(vs.71).aspx and examples of using "ordinary" connection strings , "context connection" connection strings (remember, won't work "context connection") in sqlclr here: http://msdn.microsoft.com/en-us/library/ms345135(sql.90).aspx . need combine 2 concepts 1 sqlclr proc, and, because you're using "ordinary" connection string sqlclr, make assembly external access. just write if have issues.

cheers, bob beauchemin, sqlskills

SQL Server  >  .NET Framework inside SQL Server