Change Type greyed out in 2k5 mgmt studio

in 2000 ent mgr, I can right click on a table/Query/perform a query and then
"Change Type" to update or whatever.
In 2k5 mgmt studio (against a 2000 database) I can arrange the panes to look
the same and perform the same query.
But Change Type is greyed out (on the screen). For what its work the icon
isnt there, but the words "Change Type".
Its enabled (checked) - well, I forget how I got there, but it was checked.
If I click on a table in the object explorer, its no longer grey-out, but
all the options are (which makes sense).
So - how can I Change Type graphically on a query?
You may need to logon but add your vote and comment here.
http://connect.microsoft.com/SQLServer
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124911
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"SandpointGuy" wrote:
> in 2000 ent mgr, I can right click on a table/Query/perform a query and
> then
> "Change Type" to update or whatever.
> In 2k5 mgmt studio (against a 2000 database) I can arrange the panes to
> look
> the same and perform the same query.
> But Change Type is greyed out (on the screen). For what its work the icon
> isnt there, but the words "Change Type".
> Its enabled (checked) - well, I forget how I got there, but it was
> checked.
> If I click on a table in the object explorer, its no longer grey-out, but
> all the options are (which makes sense).
> So - how can I Change Type graphically on a query?
|||I don't use the designer tools but when I played around with
it, it 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 Fri, 10 Aug 2007 10:50:01 -0700, SandpointGuy
<SandpointGuy@.discussions.microsoft.com> wrote:

>in 2000 ent mgr, I can right click on a table/Query/perform a query and then
>"Change Type" to update or whatever.
>In 2k5 mgmt studio (against a 2000 database) I can arrange the panes to look
>the same and perform the same query.
>But Change Type is greyed out (on the screen). For what its work the icon
>isnt there, but the words "Change Type".
>Its enabled (checked) - well, I forget how I got there, but it was checked.
>If I click on a table in the object explorer, its no longer grey-out, but
>all the options are (which makes sense).
>So - how can I Change Type graphically on a query?

change SQL Server 2000 Ent to Standard

How do I change a SQL Server 2000 Enterprise Edition
installation to a SQL Server 2000 Standard Edition
installation?Hi,
You need to remove sql enterprise edition and install sql standard edition.
You could do the below steps:-
1. Backup and databases (can be used if attach fails)
2. detach all the databases from sql enterrise edition
3. Remove sql enterprise edition and install sql standard with same
directory structure
4. Apply the same service pack level
5. Attach the MDF and LDF files back in standard edition.
If attach fails you could restore the database using the backup files
performed in step-1
Thanks
Hari
MCDBA
"Pooh" <anonymous@.discussions.microsoft.com> wrote in message
news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
> How do I change a SQL Server 2000 Enterprise Edition
> installation to a SQL Server 2000 Standard Edition
> installation?|||Thanks Hari. I was hoping for some sort of "upgrade"
functionality, but if that is the only way....
>--Original Message--
>Hi,
>You need to remove sql enterprise edition and install sql
standard edition.
>You could do the below steps:-
>1. Backup and databases (can be used if attach fails)
>2. detach all the databases from sql enterrise edition
>3. Remove sql enterprise edition and install sql standard
with same
>directory structure
>4. Apply the same service pack level
>5. Attach the MDF and LDF files back in standard edition.
>If attach fails you could restore the database using the
backup files
>performed in step-1
>
>Thanks
>Hari
>MCDBA
>"Pooh" <anonymous@.discussions.microsoft.com> wrote in
message
>news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
>> How do I change a SQL Server 2000 Enterprise Edition
>> installation to a SQL Server 2000 Standard Edition
>> installation?
>
>.
>|||Hi Pooh,
You should also look at this...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;268361
Peter
>--Original Message--
>Thanks Hari. I was hoping for some sort of "upgrade"
>functionality, but if that is the only way....
>>--Original Message--
>>Hi,
>>You need to remove sql enterprise edition and install
sql
>standard edition.
>>You could do the below steps:-
>>1. Backup and databases (can be used if attach fails)
>>2. detach all the databases from sql enterrise edition
>>3. Remove sql enterprise edition and install sql
standard
>with same
>>directory structure
>>4. Apply the same service pack level
>>5. Attach the MDF and LDF files back in standard edition.
>>If attach fails you could restore the database using the
>backup files
>>performed in step-1
>>
>>Thanks
>>Hari
>>MCDBA
>>"Pooh" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
>> How do I change a SQL Server 2000 Enterprise Edition
>> installation to a SQL Server 2000 Standard Edition
>> installation?
>>
>>.
>.
>|||Hi Pooh,
You have to perform the manual steps (My previous post) to downgrade from
SQL Enterprise edition to SQL Standard Edition.
But the upgrade from Standard to Enterprise edition can be done directly
using the SQL server Enterprise edition CD.
Thanks
Hari
MCDBA
"Pooh" <anonymous@.discussions.microsoft.com> wrote in message
news:436a01c47fab$18ec6fe0$a401280a@.phx.gbl...
> Thanks Hari. I was hoping for some sort of "upgrade"
> functionality, but if that is the only way....
> >--Original Message--
> >Hi,
> >
> >You need to remove sql enterprise edition and install sql
> standard edition.
> >
> >You could do the below steps:-
> >
> >1. Backup and databases (can be used if attach fails)
> >2. detach all the databases from sql enterrise edition
> >3. Remove sql enterprise edition and install sql standard
> with same
> >directory structure
> >4. Apply the same service pack level
> >5. Attach the MDF and LDF files back in standard edition.
> >
> >If attach fails you could restore the database using the
> backup files
> >performed in step-1
> >
> >
> >Thanks
> >Hari
> >MCDBA
> >
> >"Pooh" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
> >> How do I change a SQL Server 2000 Enterprise Edition
> >> installation to a SQL Server 2000 Standard Edition
> >> installation?
> >
> >
> >.
> >

change SQL Server 2000 Ent to Standard

How do I change a SQL Server 2000 Enterprise Edition
installation to a SQL Server 2000 Standard Edition
installation?
Hi,
You need to remove sql enterprise edition and install sql standard edition.
You could do the below steps:-
1. Backup and databases (can be used if attach fails)
2. detach all the databases from sql enterrise edition
3. Remove sql enterprise edition and install sql standard with same
directory structure
4. Apply the same service pack level
5. Attach the MDF and LDF files back in standard edition.
If attach fails you could restore the database using the backup files
performed in step-1
Thanks
Hari
MCDBA
"Pooh" <anonymous@.discussions.microsoft.com> wrote in message
news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
> How do I change a SQL Server 2000 Enterprise Edition
> installation to a SQL Server 2000 Standard Edition
> installation?
|||Thanks Hari. I was hoping for some sort of "upgrade"
functionality, but if that is the only way....
>--Original Message--
>Hi,
>You need to remove sql enterprise edition and install sql
standard edition.
>You could do the below steps:-
>1. Backup and databases (can be used if attach fails)
>2. detach all the databases from sql enterrise edition
>3. Remove sql enterprise edition and install sql standard
with same
>directory structure
>4. Apply the same service pack level
>5. Attach the MDF and LDF files back in standard edition.
>If attach fails you could restore the database using the
backup files
>performed in step-1
>
>Thanks
>Hari
>MCDBA
>"Pooh" <anonymous@.discussions.microsoft.com> wrote in
message
>news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
>
>.
>
|||Hi Pooh,
You should also look at this...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;268361
Peter
[vbcol=seagreen]
>--Original Message--
>Thanks Hari. I was hoping for some sort of "upgrade"
>functionality, but if that is the only way....
sql[vbcol=seagreen]
>standard edition.
standard
>with same
>backup files
>message
>.
>
|||Hi Pooh,
You have to perform the manual steps (My previous post) to downgrade from
SQL Enterprise edition to SQL Standard Edition.
But the upgrade from Standard to Enterprise edition can be done directly
using the SQL server Enterprise edition CD.
Thanks
Hari
MCDBA
"Pooh" <anonymous@.discussions.microsoft.com> wrote in message
news:436a01c47fab$18ec6fe0$a401280a@.phx.gbl...[vbcol=seagreen]
> Thanks Hari. I was hoping for some sort of "upgrade"
> functionality, but if that is the only way....
> standard edition.
> with same
> backup files
> message

change SQL Server 2000 Ent to Standard

How do I change a SQL Server 2000 Enterprise Edition
installation to a SQL Server 2000 Standard Edition
installation?Hi,
You need to remove sql enterprise edition and install sql standard edition.
You could do the below steps:-
1. Backup and databases (can be used if attach fails)
2. detach all the databases from sql enterrise edition
3. Remove sql enterprise edition and install sql standard with same
directory structure
4. Apply the same service pack level
5. Attach the MDF and LDF files back in standard edition.
If attach fails you could restore the database using the backup files
performed in step-1
Thanks
Hari
MCDBA
"Pooh" <anonymous@.discussions.microsoft.com> wrote in message
news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
> How do I change a SQL Server 2000 Enterprise Edition
> installation to a SQL Server 2000 Standard Edition
> installation?|||Thanks Hari. I was hoping for some sort of "upgrade"
functionality, but if that is the only way....
>--Original Message--
>Hi,
>You need to remove sql enterprise edition and install sql
standard edition.
>You could do the below steps:-
>1. Backup and databases (can be used if attach fails)
>2. detach all the databases from sql enterrise edition
>3. Remove sql enterprise edition and install sql standard
with same
>directory structure
>4. Apply the same service pack level
>5. Attach the MDF and LDF files back in standard edition.
>If attach fails you could restore the database using the
backup files
>performed in step-1
>
>Thanks
>Hari
>MCDBA
>"Pooh" <anonymous@.discussions.microsoft.com> wrote in
message
>news:3e4101c47fa7$c89b1850$a301280a@.phx.gbl...
>
>.
>|||Hi Pooh,
You should also look at this...
http://support.microsoft.com/default.aspx?scid=kb;en-
us;268361
Peter

>--Original Message--
>Thanks Hari. I was hoping for some sort of "upgrade"
>functionality, but if that is the only way....
sql[vbcol=seagreen]
>standard edition.
standard[vbcol=seagreen]
>with same
>backup files
>message
>.
>|||Hi Pooh,
You have to perform the manual steps (My previous post) to downgrade from
SQL Enterprise edition to SQL Standard Edition.
But the upgrade from Standard to Enterprise edition can be done directly
using the SQL server Enterprise edition CD.
Thanks
Hari
MCDBA
"Pooh" <anonymous@.discussions.microsoft.com> wrote in message
news:436a01c47fab$18ec6fe0$a401280a@.phx.gbl...[vbcol=seagreen]
> Thanks Hari. I was hoping for some sort of "upgrade"
> functionality, but if that is the only way....
> standard edition.
> with same
> backup files
> message

Change registry keys regarding to SQL and Moving databases

Platform: Window2003 ent Failover Clustering SQL Server 2k ent sp3a.
I need change some registry keys regarding to SQL, such as:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
Do I need change on all the nodes one by one?
Previously, after non-clustered default installation, I always referenced
http://support.microsoft.com/default...b;EN-US;224071 and
http://support.microsoft.com/default...;EN-US;q240867 to Move SQL
Server databases to a new location.
However, I have new windows2003 SQL server 2k sp3a setup with external
shared storage. I need relocate databases and full text indexes. I'm not
sure which way I shall follow to moving database files or change registry
keys.
These still apply to moving Clustered databases. Wherever you move the
files to, that location must be a disk resource that the SQL Service resoure
depends on.
This may be what you are looking for.
http://support.microsoft.com/default...b;en-us;295732
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:C0C4AC62-8CDC-4B60-97D3-2DE267B8E1F2@.microsoft.com...
> Platform: Window2003 ent Failover Clustering SQL Server 2k ent sp3a.
> I need change some registry keys regarding to SQL, such as:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
> Do I need change on all the nodes one by one?
> Previously, after non-clustered default installation, I always referenced
> http://support.microsoft.com/default...b;EN-US;224071 and
> http://support.microsoft.com/default...;EN-US;q240867 to Move
SQL
> Server databases to a new location.
> However, I have new windows2003 SQL server 2k sp3a setup with external
> shared storage. I need relocate databases and full text indexes. I'm not
> sure which way I shall follow to moving database files or change registry
> keys.
|||How about Registry keys? Do I have to apply node by node?
such as, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\
"Geoff N. Hiten" wrote:

> These still apply to moving Clustered databases. Wherever you move the
> files to, that location must be a disk resource that the SQL Service resoure
> depends on.
> This may be what you are looking for.
> http://support.microsoft.com/default...b;en-us;295732
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Maggie" <Maggie@.discussions.microsoft.com> wrote in message
> news:C0C4AC62-8CDC-4B60-97D3-2DE267B8E1F2@.microsoft.com...
> SQL
>
>
|||The keys are cluster-specific, not node specific. Look at:
http://support.microsoft.com/default...b;en-us;810056
and
http://support.microsoft.com/default...b;en-us;812666
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:1E721AFA-BA4F-4C38-B514-8CF57EEEC119@.microsoft.com...[vbcol=seagreen]
> How about Registry keys? Do I have to apply node by node?
> such as, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\
>
> "Geoff N. Hiten" wrote:
resoure[vbcol=seagreen]
referenced[vbcol=seagreen]
Move[vbcol=seagreen]
not[vbcol=seagreen]
registry[vbcol=seagreen]