Change from Enterprise Edition to Developer Edition

We want to install SQL Server 2005 Developer on a server that has SQL Server
2000 Enterprise edition and we are getting an error of you can't upgrade from
Enterprise to Developer. The server is not supporting production and has
never supported production; it is strictly for development activities. Is
there a way we can do that?
Thanks,
Joseph
You can uninstall Enterprise and install Developer. It will not delete any
user dbs but you should have proper backups of all dbs and scripts or a plan
to recreate logins etc if needed.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:0E3E5B6A-27ED-46B2-AA2E-F4E31363E859@.microsoft.com...
> We want to install SQL Server 2005 Developer on a server that has SQL
> Server
> 2000 Enterprise edition and we are getting an error of you can't upgrade
> from
> Enterprise to Developer. The server is not supporting production and has
> never supported production; it is strictly for development activities. Is
> there a way we can do that?
> Thanks,
> Joseph
|||Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never been
able to uninstall it cleanly. Also wanted to see how the upgrade in-place
works for 2005. I want to know if there's a way I can downgrade the
Enterprise to Developer and then upgrade.
Joseph
"Andrew J. Kelly" wrote:

> You can uninstall Enterprise and install Developer. It will not delete any
> user dbs but you should have proper backups of all dbs and scripts or a plan
> to recreate logins etc if needed.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
> news:0E3E5B6A-27ED-46B2-AA2E-F4E31363E859@.microsoft.com...
>
|||Not that I know of. I am pretty sure it will require you to uninstall EE.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:D5495DB1-1592-4339-85EA-3536AA8A81BA@.microsoft.com...[vbcol=seagreen]
> Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never
> been
> able to uninstall it cleanly. Also wanted to see how the upgrade in-place
> works for 2005. I want to know if there's a way I can downgrade the
> Enterprise to Developer and then upgrade.
> Joseph
> "Andrew J. Kelly" wrote:
|||There is no such a path is available because one of the edition is for
production\business purposes and the other one is for totally different
purpose which is development\test.
Here' s a list of available upgrade paths:
http://technet.microsoft.com/en-us/library/ms143393.aspx
Ekrem ?nsoy
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:D5495DB1-1592-4339-85EA-3536AA8A81BA@.microsoft.com...[vbcol=seagreen]
> Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never
> been
> able to uninstall it cleanly. Also wanted to see how the upgrade in-place
> works for 2005. I want to know if there's a way I can downgrade the
> Enterprise to Developer and then upgrade.
> Joseph
> "Andrew J. Kelly" wrote:

Change data type in replicated table

How do I change column data type for replicated table in SQL 2000?
(transactional replication). I need to preserve data in a column, can't drop
and re-add it.
Thank you in advance for your help!
It can't be done without dropping and readding. The way you do it is copy
the contents of the column to a temp table with pk info. Drop the column
using sp_repldropcolumn and add it again using sp_repladdcolumn
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:B358A642-812F-456D-971B-3DB14BF8D60E@.microsoft.com...
> How do I change column data type for replicated table in SQL 2000?
> (transactional replication). I need to preserve data in a column, can't
> drop
> and re-add it.
> Thank you in advance for your help!

Catch a trigger from the Grid Events

Hi,

I have one problem when I try to update one record in the data base.

Such error arises when I update a table and a trigger raises an error, I cant catch it within the Row_Updating event command and I dont know how to get it within the Row_Updated event, because the exception happes before that command.

Also, I tried in the sqldatasource updating event but I got no results.

Any idea?

thanks in advance.

Modify your procedure to catch any errors and return a message:http://technet.microsoft.com/en-us/library/ms175976.aspx