Home / server / Questions / 121064
Accepted
user28233
Asked: 2010-03-11 02:34:36 +0800 CST

How to create a server in MS SQL 2005

  • 772

I'm just a beginner and I want to know how to create a server in MS SQL 2005 because I want to use MS SQL as my database for a vb.net database program.

I'm only using a single desktop computer. What would you recommend? This will only be used as a database for a vb.net program.

sql-server-2005

3 Answers

  1. Best Answer

    If it's a single computer and a single program, then you should consider SQL Server Express instead. This page has info about the 2008 version: http://www.microsoft.com/express/Database/

    If you're beginning, consider whether you should begin with something other than VB.net. Is there a specific reason for using it? It could be a great opportunity to learn Visual C# or similar.

    • 5

  2. Read the documentation, get into some VB.NET tutorials (as in: everyone that is not totally trivial has some section about databases).

    • 0

  3. I'm only using a single desktop computer.

    I'd recommend going with an in-process or desktop engine rather than a server-class engine like sql server. Even Sql Server Express Edition is usually overkill. Use something like Sql Server Compact Edition, Sqlite, or even Access instead.

    • 0