MS SQL 2005 Yes/No? - 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

General SQL Server Forums

New to SQL Server Programming

MS SQL 2005 Yes/No?

Author

Topic

MikeTV
Starting Member

5 Posts

Posted - 2006-01-27 : 08:47:14

Please help.

I'm very new to all this. I need to know if i can use sql 2005 instead of 2000. My developers said that they can't use 2005 as its for something different and insist that i buy 2000 but from what i've read 2005 is an update, correct? or am I being had!?

Any info on this will be greatly appreciated.

Thanks.
Mike

cshah1
Constraint Violating Yak Guru

347 Posts

Posted - 2006-01-27 : 09:04:31

I would rather opt for SQL 2005, I know developers might refrain it from using it for a while but after all it is an enhancement of SQL 2000 so why not?

MikeTV
Starting Member

5 Posts

Posted - 2006-01-27 : 09:10:30

Thanks, thats exactly what i need to know. Is there anything else i should know? They will still try to tell me that only 2000 will work.

cshah1
Constraint Violating Yak Guru

347 Posts

Posted - 2006-01-27 : 09:20:01

SQL Server 2005 DVD will have "Upgrade Advisor" or you can download it from here

http://www.microsoft.com/downloads/details.aspx?FamilyID=6107C27A-662C-4319-AFE7-B52D1568C30A&displaylang=en

Downlaod and install it. Upgrade Advisor identifies deprecated features and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.

MikeTV
Starting Member

5 Posts

Posted - 2006-01-27 : 09:43:37

Is the 2005 edition specificly designed for .net? My developer is still saying that he cant use the 2005.

Thanks

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2006-01-27 : 09:46:20

2005 would have more functionality than 2000. sounds like a developer is spouting sh*te.

MikeTV
Starting Member

5 Posts

Posted - 2006-01-27 : 09:47:31

Thanks for your help so far cshah1.

Norwich
Posting Yak Master

158 Posts

Posted - 2006-01-27 : 10:48:31

Quick Note:

.Net 2003 runs on Framework 1.2 (if I'm not mistaken) and SQL 2005 runs on Framework 2.0
Just make sure that you won't pick up any errors in your environment.

I've been using 2005 for a few months and it has greatly enhanced my productivity but then I only work in SQL!

Regards
N

The revolution won't be televised!

MikeTV
Starting Member

5 Posts

Posted - 2006-01-27 : 11:44:17

Thanks guys.

So the bottom line is that there is absolutly no reason why i cant use 2005 over 2000?

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-01-27 : 12:02:02

Sounds funny to me, but every new product has an advantage over the old, if you must go with 2000, you would have to install all service packs etc

As advice, go for 2005

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources