November 25, 2003 at 4:20 pm
Hi All, Anyone knows if one can log all outputs generated by the various T-sql statements hitting a sql server? The app. team's been complaining off receiving malformed output record sets and they think sql server is responsible. I know one can use profiler to list or watch all incoming queires. How does one log what result set is being returned back? All ideas are welcome. Gracias..
November 25, 2003 at 5:19 pm
The only way I know of is to actually sniff the network. You can see the result sets from Query Analyzer and I'd be extremely surprised if there were malformed result sets. I've never seen these in years of SQL Server work. How is the app connecting?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 26, 2003 at 4:40 pm
Hi Steve, Appreciate your input. I am of the same opinion that over years of working with sql server, this was the first time I heard this time of complaint. Fortuantely, it now appears that the app. team has located the problem and it is a middleware issue. Client in this case is ASP pages hitting sqlserver..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply