How to Change Query Type ?(Mangagement Studio)

Why the "Change Type" Button of the "Query Designer Toolbar " is alwayse Disable(gray color) ,then how can i switch the query between "selelct","update","Insert" and "Delete"? I am using Nov 7 released 180 Days Trial Version.(Sql Server Management Studio)

Thannks!

The Query toolbar is associated with Query Designer documents. The only way to display such a document in Management Studio is using the Open Table/Open View functionality for tables or views. The change type drop down is disabled in Open Table because we don't allow the Visual Studio Query Designer (which is displaying the query) to change the query type for Open Table. In Visual Studio, this restriction is lifted for Query Designer documents.

You can do what you want to do by creating a new query (click the New Query button), typing some text (say, "select"), highlighting the text you typed, right-clicking to bring up a context menu, and selecting "Design Query in Editor." In the Query Designer dialog that appears, you can right click in the upper pane and add tables. You can also right click and change the query type from the context menu.|||I see,Thank you for your Reply

How to cancel report?

Hi,
I have an application with RS reports. When user runs a report, I want to
have a button Cancel Report. I can find the jobID for this report and cancel
it, but cursor on IE is still an hourglass and green circle with the text
"Report is being generated" are still in the center of the browser. Is there
any way to let RS know that it should stop to do everything for this session
because current job is already cancelled?
Maybe I even can get some feedback from RS that it is cancelled and I can
suppress my Cancel button?
Any suggestions?
Thanks.
Victor
P.S. If Microsoft guys will read this: Are we going to have in the future
Cancel button?
Thanks.Anybody... Anything...
"Victor" wrote:
> Hi,
> I have an application with RS reports. When user runs a report, I want to
> have a button Cancel Report. I can find the jobID for this report and cancel
> it, but cursor on IE is still an hourglass and green circle with the text
> "Report is being generated" are still in the center of the browser. Is there
> any way to let RS know that it should stop to do everything for this session
> because current job is already cancelled?
> Maybe I even can get some feedback from RS that it is cancelled and I can
> suppress my Cancel button?
> Any suggestions?
> Thanks.
> Victor
> P.S. If Microsoft guys will read this: Are we going to have in the future
> Cancel button?
> Thanks.
>