|
Home > Archive > MS SQL Server > February 2006 > sql server 2005 "Change Type" is grayed out
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql server 2005 "Change Type" is grayed out
|
|
| Steven K0 2006-02-11, 8:23 pm |
| Hello,
I am trying to create an update query using the following steps:
Right mouse click on table
Select "open table"
Once I click on the table, I can select most items from the "Query Designer"
toolbar. I can select the Diagram, Criteria, SQL and Results pane.
However, the "Change Type" is grayed out. How do I use this function on the
toolbar? Also, If I manually change the query to an update query in the SQL
pane, it works fine.
--
Thanks in advance,
Steven
| |
| John Bell 2006-02-12, 7:23 am |
| Hi Steven
This does not seem to work as expected! There are other issues raised about
functionality that was in EM for this function that is no longer available,
but you may want to raise this as a separate issue
athttp://lab.msdn.microsoft.com/productfeedback/default.aspx
John
"Steven K0" <stroy@api.com> wrote in message
news:%23MV9ZD2LGHA.1676@TK2MSFTNGP09.phx.gbl...
> Hello,
>
> I am trying to create an update query using the following steps:
>
> Right mouse click on table
> Select "open table"
>
> Once I click on the table, I can select most items from the "Query
> Designer" toolbar. I can select the Diagram, Criteria, SQL and Results
> pane. However, the "Change Type" is grayed out. How do I use this
> function on the toolbar? Also, If I manually change the query to an
> update query in the SQL pane, it works fine.
>
> --
> Thanks in advance,
> Steven
>
|
|
|
|
|