[SQL Server] Switch to Messages tab programatically

Is there any way to switch to the Messages tab programatically so that my users can see the progress of script execution and what is being printed in the Messages window?

Attachment 81704

See if this helps...

http://stackoverflow.com/questions/3...rogramatically

http://msdn.microsoft.com/en-us/library/ms180944.aspx

Sid

His problem is exactly same as mine, but no solution mentioned there. :(

Any way to switch it to "Results to Text" programatically? That only has one window tab.

Quote:

---

Originally Posted by szlamany

Any way to switch it to "Results to Text" programatically? That only has one window tab.

---

This is also worksome if there is some way, as the purpose of showing progress messages is fulfilled. Is there any such way?

There is one way I know of, to switch to that window: Raise an error and print something using the RAISERROR statement.
But I don't want to use that unless there are no other options because it prints in red (like a real error message) and might scare the user running the query.

Quote:

---

Originally Posted by Pradeep1210

There is one way I know of, to switch to that window: Raise an error and print something using the RAISERROR statement.
But I don't want to use that unless there are no other options because it prints in red (like a real error message) and might scare the user running the query.

---

Isn't there some way to change the severity level so that it doesn't come up red?

Quote:

---

Originally Posted by szlamany

Isn't there some way to change the severity level so that it doesn't come up red?

---

If we change the severity level to low, then it would print immediately (in black like the PRINT command), but it won't automatically switch to the Results tab.

So I have
bad fonts and switch to Results tab immediately,
or good fonts but no automatic switch to Result tab.
:(

If it's going to be RED then make it large and obvious that it's not an error like

******* THIS IS THE START OF THE SCRIPT - successful progress will appear in black below *******

so that they don't wonder about it.

Hmm.
This is a peculiar request.
I suppose you could try to create an add in and have a command console to execute your sp.
But i cannot say i ever tried that.
http://jcooney.net/post/2007/11/26/T...05-Add-In.aspx