Getting results back from SQL server as text

[Cakkie]

Houston, I have a problem. I need to retrieve text from the SQL server. Anyone who has ever worked with Query Analizer must know what I mean. For those who don't (or forgot), I mean the text that is returned when running a statement (like X rows affected). Actually, I'm more after the text that is returned by stored procedures (including generated by the print statement).
This is because I need to get information about the path the procedure followed. This information is outed with the print statment.
Also would it be handy to get a real error message instead of '-201354215 method execute of connection failed'

Thanx

Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook

[Johnny101]

I dont think there's anyway to get that text like in QA. However, there are at least two other ways i can think of at the moment.

1) if you added an output parameter to the stored procs, then replaced the PRINT statements with SET @OutBoundVar = @OutBoundVar + 'something else you want to relay' statements - wouldn't that do it?

2) Insert those "reporting statements" into another table and then issue a SELECT from there - the stored proc can bring back more than one recordset - and you're code can use it if it wants, otherwise, it will just ignore it.

let me know if you'd like more detail about either of those scenarios.

john

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org