| Author |
Topic |
|
Flaxmac
Starting Member
4 Posts |
 Posted - 2007-04-15 : 23:17:35
|
| Hi,I am trying to make a small vb.net program in visual studio 2005 edition. I would like to have a SQL database with it.I have the Microsoft Visual Studio and SQL Server 2005 installed on my PC. I am running XP but will be moving it all to a new pc running Vista next week.How to I get the SQL database started ?I am not using the express edition. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-15 : 23:21:08
|
"How to I get the SQL database started ?"You can start the SQL Server by going to Control Panel - Services and look for SQL Server and start the services.Or use SQL Server Management Studio.
KH |
 |
|
|
Flaxmac
Starting Member
4 Posts |
Posted - 2007-04-15 : 23:28:58
|
| I think the service is already running.I want to know how I can access it.Just like if you have an ACCESS database you save it to the folder you want to put it in. To start it up you click on it. How do I do that with SQL 2005 ? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-15 : 23:33:22
|
SQL Server is different. The database engine is running as a services in the background. You don't click on the database file to start it. Once the database engine is running, you can connect to the database from your application or you can use the SQL Server Management Studio to code / test out your query.
KH |
|
|
|
Flaxmac
Starting Member
4 Posts |
Posted - 2007-04-15 : 23:45:23
|
| First thanks for the help, so far....So how dow I make the database name that I want ? eg 'Sales Data'.How do I add tables to it ?I wasn't able to see the "SQL Server Management Studio".I do use Enterprise Manager with SQL 2000. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-16 : 00:09:59
|
quote:
Originally posted by Flaxmac
First thanks for the help, so far....So how dow I make the database name that I want ? eg 'Sales Data'.How do I add tables to it ?I wasn't able to see the "SQL Server Management Studio".I do use Enterprise Manager with SQL 2000.
quote:
I have the Microsoft Visual Studio and SQL Server 2005 installed on my PC
Are you using SQL Server 2000 or 2005 ?
KH |
|
|
|
Flaxmac
Starting Member
4 Posts |
Posted - 2007-04-16 : 00:33:42
|
| I think I have both |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-16 : 00:39:40
|
You can only use Enterprise Manage to manage a SQL Server 2000 but not SQL Server 2005. SQL Server Management Studio can managed both 2000 and 2005.If you need to create the table in the SQL Server 2005, use Management Studio else you can also use Enterprise Manager to do it.on Enterprise Manager, Right click on the database, New - Tableon SQL Server Management Studio, navigate to the database, right click on the "Tables" - New Table
KH |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
Getting Started