[SQL Server] Switch to Messages tab programatically

[Pradeep1210]

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?

[Siddharth Rout]

See if this helps...

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

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

Sid

[Pradeep1210]

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

[szlamany]

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

[Pradeep1210]

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?

[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.

[szlamany]

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?

[Pradeep1210]

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.

[szlamany]

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.

[sapator]

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