Print

[deanoA]

If I have the code in my stored proc: print 'Hello' Is the string hello retrieved? in my case, does my asp.net code acquire the value 'Hello' when it calls the procedure? 'Hello World'

[Mike Dimmick]

My handy reference Inside SQL Server 2000 says that a PRINT statement is returned as a message with severity 0. It looks like you can trap these by handling the SqlConnection's InfoMessage event. Note: not tested. If you need to return a string as a result set, use SELECT instead.