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 |
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 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
|
|