up vote 0 down vote favorite
share [g+] share [fb]

I have an application that currently runs on SQL 2000, on a server with Windows 2000. The hardware has just about run out of useful life - HD's are almost full, more users than 2gb ram can cope with etc...

I've got it's replacement ready. It's Windows Server 2008 x64 - Which I cannot install SQL 2008, as it isn't compatible.

We're in the process of upgrading to SQL 2008 across our organization. My question is - I've installed SQL 2008 onto this machine. My idea is to create a database on this, in 2000 compatibility mode.

Will this work....? In terms of "old" or depreciated queries etc... (I'm not sure if there are any)

Is this my best bet?

link|improve this question
56% accept rate
1  
see: serverfault.com/questions/98352/… – Zypher♦ Dec 31 '09 at 16:06
thanks, sorry for the duplicate! i HATE doing that... there was nothing that came up when I typed the question though! – alex Dec 31 '09 at 16:19
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.