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 |
|
etietje
Starting Member
24 Posts |
 Posted - 2005-04-21 : 11:28:17
|
| Hello everybody. I am writing a stored procedure that conditionally calls another procedure then sends a custom select query to the results tab. The problem I'm having is that the procedure it is calling is printing all sorts of messages that show up before my query is displayed. I cannot change the procedure that is called so I need to either find a way to not display it's messages or clear the results tab before I print my query. Does anybody know how to do this? Thanks a lot in advance! |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-21 : 11:38:34
|
| You should not use Query Analyzer as part of an "application" solution.You should have the process write the results of the sproc to a table, then have a driver sproc bcp the data out to a file.What message are you refering to? Row affected?SET NOCOUNT ONBrett8-) |
 |
|
|
etietje
Starting Member
24 Posts |
Posted - 2005-04-21 : 11:44:07
|
| I know this isn't the best solution, but we are a small data shop that is still building many apps to automate things, but still have to do almost everything by hand. I already have the SET NOCOUNT ON in my procedure, but the procedure I'm calling actually PRINT's messages, and I can't change that.Eventually I will put this in an app that will be prettier, but I'd like to find a solution for the short term.Thanks for the comments though, I appreciate it. |
|
|
|
|
|
|
clear results tab