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 2005 Forums
 Other SQL Server Topics (2005)
 real-time feedback from scripts

Author  Topic 

jholovacs
Posting Yak Master

163 Posts

Posted - 2008-01-10 : 16:35:06
I'm sure just about everyone uses the PRINT command to give feedback as to what their lengthy and involved scripts are doing, as sort of a record.

I cannot figure out how to make the stuff I use in PRINT commands come out in real-time like SELECTs seem to. Does anyone have an answer to this? These are long-running scripts, and I'd rather nip a problem in the bud before the entire script completes if there's a problem I can capture.

___________________________
Geek At Large

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-01-10 : 16:55:45
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

jholovacs
Posting Yak Master

163 Posts

Posted - 2008-01-11 : 09:51:10
sounds like what I'm looking for, thanks.

___________________________
Geek At Large
Go to Top of Page
   

- Advertisement -