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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 print not works while running SP from QA

Author  Topic 

joseln
Starting Member

11 Posts

Posted - 2008-01-14 : 03:28:57
Hi

I have written 2 different stored procedures(SP) each got print statement inside for testing the results. when i run these 2 SPs from Query Analyzer, one return the print result immediately once print statement executed i.e., in the mid of SP executes that i see in "message" tab while the other return the print statement only after the SP query batch completed.

What is the setting change?. how do i do the settings in sql server to see the print result from the message tab at the time of SP executes in QA?.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-01-14 : 03:59:04
http://weblogs.sqlteam.com/mladenp/archive/2007/10/01/SQL-Server-Notify-client-of-progress-in-a-long-running.aspx

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out
Go to Top of Page
   

- Advertisement -