February 14, 2008 at 8:39 pm
I am new here this is my very 1st post so forgive me if Im in wrong area.anywaysI have a pc Im on and it has xp home sp3(yes believe it)and it has the 2002 version which Im guessing thats the sql? but anyway can I switch to a newer sql server? reason to get best performance outta my pc? any input is very helpful.thanks alot.
February 14, 2008 at 9:24 pm
sql server does not have a 2002 version. There is 6.5, 7.0, 8.0 (2000), and 9.0 (2005), 10.0 (2008). I am not certain what that would have to do with your PC. If you are running xp home sp3 then the most you could have is a compact desktop edition. None of which should be running on your home PC with out a good reason.
Hope that helps. If not please clarify your question.
February 14, 2008 at 9:32 pm
system properties says this
System
Microsoft Windows XP
Home Edition
Version 2002
Service Pack 3, v.3264
Registered to
Me
xxxxx-xxx-xxxxxxx-xxxxx
Computer
Intel [R]
Pentium[R] 4 cpu 3.00 ghz
3.01 ghz 960 mb of ram
physical address extension
February 14, 2008 at 10:02 pm
Hi,
Journeyman is r8 and version 2002 is not your SQL version number if u want 2 see your SQL version number please try this :
select @@version
Best Regards
Faheem latif
Senior Database Architect
Genie Technologies (Pvt.) Ltd.
February 14, 2008 at 11:05 pm
what info I got is 2000 5.1 if that helps?
February 26, 2008 at 11:34 pm
not certain if it will work with the application using sql server compact edition but there is a sql server 2005 compact edition. SQL Server 2008 is due to be released in April and I am sure 2008 will have a compact edition. 2005 should work with xp home edition sp3 but I am fairy certain the 2008 version will not.
Hope that answers your question.
February 27, 2008 at 9:26 am
Yes you can move your sql server to a new PC and can access from it.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply