Which SQL Server 2000 or 2005?

[LouisC4]

Hello, I have installed Visual Studio 2005, SQL Server 2005 and SQL Server 2000.

I managed to create a database using the Server Explorer in VS. How can I tell which engine (SQL Server 2000 or 2005) the database I created is running in?

I need to create my database and tables in SQL Server 2000 since my website host does not support SQL Server 2005.

Thanks in advance,

Louis

 

[gmmastros]

One way...

Click Start->Run
Type services.msc
Click OK

Each instance of SQL Server has a service.

For SQL 2000, the service will be MSSQLSERVER.
For SQL 2005, the service will be SQL SERVER

Each will have parenthesis with the instance name in it (or no parenthesis for the default instance).

So... stop 1 of them and see if visual studio keeps working (or not). By process of elimination, you should be able to tell which instance you are connected to.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LouisC4]

Thanks George,

Another question. I have stopped SQL 2005 and I have SQL 2000 running.

What do I do to create a new database in SQL 2000? When I try to Add New Item -> SQL Database it gives me this error message: "An error has occurred while establishing connection to the server. When connecting to SQL Server 2005 ... "

Which is obvious that SQL Server has been stopped.

So my main concern is to establish connection with SQL Server 2000 and create my new database in SQL Server 2000 now that SQL 2005 has been stopped.

Thanks again,

Louis

 

[gmmastros]

I don't use visual studio server explorer, but...

At the top of the window, click "Connect to database".
An Add Connection dialog will display. Just step thought the wizard, making sure you select the SQL 2000 instance.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LouisC4]

George, is it possible to work with SQL 2005 on my desktop creating the database and the tables and all the ADO commands using VS C#, then recreate the database and tables exactly the same in SQL 2000 MSDE using SQL Management Studio Express. Then detaching the SQL 2000 database and attaching it to my web hosting server. Would my website still work after I upload it to my web hosting server?

I hope I am making sense.

Thanks,

Louis

 

[gmmastros]

Uh.... I'm not sure.

Obviously, there are new features in SQL 2005, so scripting the objects and running the script on MSDE 2000 may not work.

Honestly, if it were me doing this... I would forget about sql 2005 until your hosting company supports it. The old, "Better safe than sorry" adage. Ya know. Alternatively, you could try to find a hosting company that does support 2005?

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LouisC4]

Honestly, if it were me doing this... I would forget about sql 2005 until your hosting company supports it. The old, "Better safe than sorry" adage. Ya know. Alternatively, you could try to find a hosting company that does support 2005?

I agree, but I don't know how to go about that. My problem is getting SQL 2000 to open up on Visual Studio 2005 so I can start working with it. Every time I try creating a database it defaults to SQL 2005. I stopped SQL 2005 so that SQL 2000 alone would be running and I still can't get to setup a database in VS. I also created the database and tables using Management Studio Express then I detached it and try to attach it to VS but it tells me that it can't connect to SQL 2005 because it's down.

I don't know how to go about this.

Thanks so much for your help,

Louis

 

[gmmastros]

Perhaps you should post a question in one of the visual studio forums (ex: vb.net or asp.net). I'm sure someone in one of those forums would know how to use MSDE 2000 with visual studio.

Sorry I couldn't help more.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LouisC4]

Thank you, I will do that.

Louis