SQL Server setup - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

SQL Server setup

Author

Topic

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-08-20 : 07:44:26

Hello all,
I dont know whether i am posting topic on correct forum or not.

I am very new to sql server installation.
I have done a lot of programming but i am infant in this.
I have sql server installed on my machine
version -

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 3)

and serverproperties are


productversion	productlevel	edition
9.00.3042.00	SP2		Express Edition with Advanced Services

And server of our office is located at another machine
its version is
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

and server properties are -


productversion	productlevel	edition 
9.00.4035.00	SP3		Enterprise Edition (64-bit)

Now I want to be in sync with that version.
What should be my steps to go for it.
I am really not able to find on internet about this.

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-20 : 12:23:48

To get to build 4035, you just need to install service pack 3 for SQL Server 2005.

You won't be able to switch to Enterprise Edition though as that requires an expensive license and a server operating system.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources