Under what conditions is 'Change Type' available? I used to use it a lot
with EM2000. If I choose 'Open Table' in Object Explorer then 'Change Type'
dropdown is grayed out.

Looks like you have to be in the Query Designer to get that
functionality.
1. From the toolbar, select new query
2. On the new query window, right click and select Design
Query in Editor
You can right click on the panes in this designer and select
Change Type.

-Sue

On Sun, 17 Sep 2006 20:23:55 -0600, "Dave Patrick"
<DSPatrick@nospam.gmail.com> wrote:

Show quoteHide quote

Yes that's one very round-about way to get there. 'Change Type' on the
'Query Designer' toolbar is still grayed out.

Show quoteHide quote

Well...the most direct way is to not use the designer at all
and just type of the query though.
I can't explain why they changed some of the functions,
features in Management Studio.  I don't think MS can explain
it other some features are "being considered for future
release" type of thing.
You could check the product feedback center for more
information and see if it's listed:
http://lab.msdn.microsoft.com/productfeedback/

-Sue

On Mon, 18 Sep 2006 08:03:45 -0600, "Dave Patrick"
<DSPatrick@nospam.gmail.com> wrote:

Show quoteHide quote

Thanks for your time looking at this Sue. I appreciate it. Since the
toolbars seem to empower some intelli-sense I was just hoping there was a
way to make the button work. Also thanks for the link, I'll look around
there.

Show quoteHide quote

Here's the "answer"

We grayed out this option from our standard Query menu tool bar to avoid a
possible situation where you would select the Delete command and when
pressing the Execute button would result in the table data being deleted.

You can add comment to the active item;

FeedbackID=124911
http://connect.microsoft.com/site/sitehome.aspx?SiteID=68

Yeah...I figured there would probably be something in there.
I haven't logged in since they changed the registration. I
still haven't figured out why they need a persons age,
address and such to be able to view feature requests, design
issues/bugs.......

-Sue

On Mon, 18 Sep 2006 09:10:53 -0600, "Dave Patrick"
<DSPatrick@nospam.gmail.com> wrote:

Show quoteHide quote

Bug in Enterprise Manager (SQL 2000)
copy database error 12291 and 208
SQL Server 2005 Activity Monitor doesn't show connections from Windows 98 clients
differnt execution plans for same query
Import Data succeeds but doesn't copy data?