.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Upgrade Desktop Engine (MSDE 2000) to standard Edition 2000

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
Hi All,   I need to upgrade from MSDE to SQL server 2000 Standard Edition how can we proceed with this. I am new to this and any help will highly appreciated. What are the things i should take care before going to this version up gradation ?

View Complete Post

More Related Resource Links

Why upgrade is required from SQL Server 2000 to SQl Server 2008

Hi all Can some body share with information about "Why upgrade is required from SQL Server 2000 to SQl Server 2008?"   This question was raised by my Boss why upgrade is required.   I stared saying   My: there is no more   support for SQL Server 2000 from Microsoft   Boss: what you will do  as DBA, Why Required Microsoft support   My: 2008 having very good features where 2000 not have...like Compression, resource governing. .Etc..   Boss: do you mean Database backup compression take full backup and compresse it using ZIP   Finally He (Boss) told me that give document proof why I have go for SQL Server 2008 and what down time you required?   Some body help me why really SQLServer 2008 is required and what are benefits   I have a link; please provide your greatest ideas so that I can convince my Boss.   http://www.mssqltips.com/tip.asp?tip=1462   share your greate Ideas please....   Thanks in Advance     SNIVAS

Upgrade SQL Server 2000 to SQL Server 2008 in Cluster--Recomendations

Hi all I have   6 cluster environments and 10 standalone servers and mix  of  32 bit  64 bit. As I know In place Upgrade not possible SQL2k 32 bit to SQL2008 64 bit. What I want to know is……… 1. If I purchase SQL Server 2008 Ent edition that will have both 64 bit and 32 bit edition or I have purchase separately ? 2. How to do side by side upgrade in Cluster environment I mean I can’t ask my company to provide other cluster to do side by side upgrade. If I do installation in same cluster machines, I can’t provide same Instance name for SQL Server 2008 Instance.hance it is very difficulty for application connectivity Please some body provides me best approach to drive in Upgrade from SQL2k to SQL2008. Thanks in Advance      SNIVAS

sql server 2000 to SQL Server 2008 in place upgrade -- Upgrade advisor help

Hello Every body Please advise me the steps i am following are correct I need to improve some more... I want upgrade from sql server 2000 to SQL Server 2008, Plese confirm the steps 1.Setup Test SQL Server 2000 similar to Production SQLServer 2000. 2.Setup other server with SQL Server 2008. 3.Install the Upgrade advisor in SQL Server 2008 system 4.Select the  Play back(under "sql server 2000 server") in Upgrade advisor tool  and fill the SQL Server2000 Server name and authontication. 5.Click on Capture play back(take the all the backups run some top 10 queries or application on top of SQL server 2000) 6.Please in shared drive(whcih can access by the SQL Server 2008 server) 7.Now click the "setup the test server" 8.Now click the upgrade test server 2008.. 9.camapre the trace files 10.View the Trace files differance. some body help me and plese confirm those steps are correct...I am in right direction..SNIVAS

in-place upgrade in cluster environment(2000 to 2008),How to do compatabilty Test ???

Hi all As of I know there are three tools are involved in Upgrade process. 1.UpgradeAdvisor 2.RML utility 3.SQL Server Upgrade Assistant. I want do compabilty test...which tools in Best for that...  Thanks in advanceSNIVAS

migration MSDE 2000 SP3 database to SQL 2005 SP3: low performance on 2005 Express

I've detach MSDE 2000 SP3 database. I've attach into SQL 2005 Express SP3 and SQL 2005 Standard SP3. I've change compatibility level to 90. I've update statistics with EXEC sp_MSforeachtable @command1="UPDATE STATISTICS ? WITH FULLSCAN" The execution time of a TSQL into the same hardware (1 CPU, Quad Core) are: SQL 2005 Express SP3: 20" SQL 2005 Standard SP3: 0" The execution plan is different. Why?

Upgrade SQL 2005 standard Runtime edition to SQL 2005 standard edition full version

We have a MS SQL 2005 standard edition runtime license. The SQL Server Runtime license is a license that lets an independent software vendor (ISV) embed the complete SQL Server code into a solution for use only by the ISV application. The customers of the ISV cannot use this SQL Server product to run other applications or to develop new applications, databases, or tables. Now we want to add a new database to the SQL. We know that we have to buy a full version of SQL 2008 standard edition. But the question is: How can we add a new database to the existing SQL. Do we have to uninstall SQL runtime license and install the full version and migrate the existing databse or can we change the key and add new databases to the SQL server?

Your upgrade is blocked.. when adding components to SQL 2005 Standard Edition SP1

Name: Microsoft SQL Server 2005 Tools Hello, I am having a problem when trying to add the Client Components to an existing installation of SQL 2005 Standard Edition SP1 running on Windows 2003 Standard. The server was originally built with SQL 2005 Standard Edition and had SP1 installed at a later date. I am using the CD that SQL was originally installed with which is not a service packed copy of SQL. The reason given when clicking the details button is as follows: Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Build version check: Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove. Any help would be greatly appreciated. Regards Steve

0x80040154 error processing a cube from SQL Server 2008 R2 x64 database engine to OLAP Server 2000 x


I recently upgrade from SQL Server 2000 x32 to SQLServer 2008 R2 x64 but only the database engine not the Analysis Server, I used to use this code to proces the cubes.


but now it do not  work more with the error:
Error at create server:
Error      Source                    Description          HelpFile HelpID
---------- ------------------------- -------------------- -------- -----------
0x80040154 ODSOLE Extended Procedure  Clase no registrada NULL     0

(1 row(s) affected)

I found this article:

It means that I can not process the cube using the same method any more ?

Can I install Sql Server 2000 PERSONAL EDITION on 64bit macine


I have a 64 bit Windows 7 machine. Can I load Sql Server 2000 PERSONAL EDITION on my machine?

If not what can I do?

Thank You


Upgrade SQL Server 2008 Standard Edition to 2008 R2

I'm trying to find the right down load to use to upgrade SQL Server 2008 Standard Edition to Standard Edition R2.  This is the first upgrade I've done for SQL Server and I can't find any download for R2 that is specifically for Standard Edition.  Can anyone point me in the right direction please?

sql 2000 Enterprise RTM upgrade to 3a



We plan to upgrade existing sql server enterprise 2000 RTM to SP3a(Chinese Traditional). Since we want to keep all the data after upgrading, can we use the original database backup(RTM) and restore to new version(Sp3a) without any error?

P.S: The RTM database backup have only basic item such as table, storeproc, index, without any replication items.

Thanks and regards,




Unable to "upgrade" SQL 2008 Enterprise to Standard Edition - Error: the credentials you provided fo


I already tried changing the logon account for SQL services and still receive the error.

Please help.

how to upgrade moss 2007 standard edition from enterprise trail version.



i have one problem in my server.

it's trial version is expired.

Initially we deploy a trial version of moss 2007 enterprise edition.

Now i have moss 2007 standard edition with key, but it's not work on server.

Kindly suggest how to activate  standard edition.

and i want to switch SQL server to another server which is presently on same server.

Please response asap.

Ankit jain



does sql 2000 msde have sql agent


I have one sql 2000 server, but cannot connect from my remote enterprise manager, locally has no sql tools installed, how to check the edition? there is agent installed, does this mean it is not msde?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend