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.
| Author |
Topic |
|
bghodsi
Starting Member
7 Posts |
 Posted - 2009-11-23 : 10:31:49
|
| Hi Folks:I had difficulty installing sql server 2008 on my computer running on Windows Xp. When I finally succeeded installing the software, I discovered that I was unable to run my sql server 2000 programs written in visual studio 2003.Questions:1. Can you have sql 2000 and sql 2008 on the same computer?Point of information I have purchased sql server 2008 developer Edition. I was going to upgrade from sql 2000 to sql 2008. But the software is not designed to handle it.2. Can you run database programs prepared using sql 2000 in sql server 2008?After uninstalling sql server 2008, I was able to attach my database using sql server 2000.Your early response will be appreciated.bghodsi@verizon.net |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-23 : 11:32:44
|
| have you installed it as a different instance or did you go for upgrade? |
 |
|
|
aks27
Starting Member
1 Post |
Posted - 2009-11-23 : 12:01:15
|
| hi u cannot install sql 2000 and 2008 instances on the same computer. since u have the windows xp i think u might be using developer or any express edition ...u can upgrade from 2000 to 2008 using enterprise edition features only.... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-23 : 12:45:16
|
| 1. What version of 2000?2. Yes, as long as they don't use discontinued features |
|
|
|
bghodsi
Starting Member
7 Posts |
Posted - 2009-11-23 : 17:05:32
|
quote:
Originally posted by aks27
hi u cannot install sql 2000 and 2008 instances on the same computer. since u have the windows xp i think u might be using developer or any express edition ...u can upgrade from 2000 to 2008 using enterprise edition features only....
Hi:Thanks for the information. Do you know if you can attach sql server 2000 databases to Visual studio 2008?Bob Ghodsi |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-23 : 21:35:01
|
| a) it is possible to install them side by side, though i haven't done that. again, what versions are you using.b)what do u mean attach a database to visual studio? |
|
|
|
bghodsi
Starting Member
7 Posts |
Posted - 2009-11-24 : 12:42:27
|
| I have sql server 2000 (sql server desktop engine) and sql server 2008 developer edition.By attaching to Visual Studio 2008, I mean that connection is made between the two.Bob Ghodsi |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-24 : 13:39:52
|
| yes you should be able to connect |
|
|
|
|
|
|
sql server 2000/sql server 2008