Re: Enterprise to Standard Edition

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Gary,

this should possible. AFAIK, there are no differences in file structure
between SQL Server editions (except for SQL Server mobile and perhaps SQL
Server Express, not sure about that). And since the system tables (of your
user data base) are included in the data base, they will be reattached as
well anyway. If you referred to the system tables of the master db, you
shouldn't have to move them. Just make sure you have the same users set up
in your Standard Edition instance so the database accounts can be mapped to
the sql server logins.

Best regards,
Nils Loeber

"Gary Hindson" <garyhindson@xxxxxxxxxxx> schrieb im Newsbeitrag
news:uPevgyZfGHA.4004@xxxxxxxxxxxxxxxxxxxxxxx
Hi

Does anyone know if it is possible to detach database's from SQL 2000
Enterprise edition and re-attach them on Standard Edition? If so is it
also possible to do this with the system tables?

Thanks

Gary



.

Relevant Pages

  • Re: Can I install SQL Server Enterprise on Windows 2000 SBS
    ... I don't think you can create indexes on views via Enterprise Manager, ... topic "Creating an indexed view" in SQL Server Books Online. ... > I create a view in SQL Server (Standard edition in my SBS) ... >>> Enterprise edition says requires Windows 2000 Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Microsoft Forefront Client Security on SBS 2003 R2
    ... purchase the SQL 2005 standard edition as well as the CALs just as Cris ... we can install SQL Server 2005 Standard Edition on Windows Small ... SQL Newsgroup: microsoft.public.sqlserver.server ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server Personal Edition
    ... Does the MS SQL Server 2000 Standard Edition that is included on ... the Small Business Server 2000 Premium edition include MS SQL Server Personal ... it would have also included Personal Edition. ... > purchased it bundles with Small Business Server (because I told hime that SBS ...
    (microsoft.public.windows.server.sbs)
  • Re: Standard to Enterprise
    ... You'll need to uninstall your Enterprise Edition and install a Standard Edition from scratch. ... instances of SQL Server services are both Standard Editions or Enterprise ... > different edition of Notification Services. ...
    (microsoft.public.sqlserver.setup)
  • RE: Versions and reccomendations
    ... > Then you could interact with up to three outside companies using BTS 2004: ... > PeopleSoft Systtem, SAP System, and Sql Server. ... > would have to upgrade to the Standard Edition to be legal. ... > license, ...
    (microsoft.public.biztalk.general)