SQL Server

[Gensor]

I'm new to SQL Server and I have some questions about it.

First of all, I'm usually used MS Access DB.

The first question may sound studio but does the name SQL Server means it needs to be installed on a server ?

With MS Access, I could create small db and put it in the application folder but can I do this with SQL Server or for this I should continue using Access ?

[k3pos]

From my opinion use Access databases for computer only applications
if you want to do "computer - internet" use SQL

BTW: yes i think it need to be installed on the server

-k3pos

[kaffenils]

SQL Server 2000 must run as a service. With SQL Server 2005 you can access the database file directly in the connection string, but I don't know how performance, multiuser and functionality will be compared to running it as a service.

[si_the_geek]

SQL Server is designed to be run on a Server, but the free versions (MSDE [2000], and SQL Server 2005 Express Edition) can be installed on desktop OS's too.

The installation of the database is slightly more awkward than with Access databases, but you gain in other areas such as security, reliability (no need for a regular Compact & Repair like with Access DB's), and much better handling of multiple users.

I haven't tested thoroughly, but there doesn't seem to be an obvious speed difference between Access and SQL Server 2005 Express when using them from VB.

[GaryMazzone]

That speed difference could be obvious in very complicated queies if you use stored procedures insead of inline SQL to gather the data. The stored access paths when using the stored procedures could get you some speed gains.

[szlamany]

SQL Server 2000 must run as a service. With SQL Server 2005 you can access the database file directly in the connection string, but I don't know how performance, multiuser and functionality will be compared to running it as a service.

It still runs as a service when you open it in the connection string - SQLSERVER.EXE still runs and listens on it's ports as if the DB was permanently attached.

I've not fooled with it but I'm guessing you can several users connect to the DB even if they "connect/attach" in the connection string.

[kaffenils]

It still runs as a service when you open it in the connection string - SQLSERVER.EXE still runs and listens on it's ports as if the DB was permanently attached.

I've not fooled with it but I'm guessing you can several users connect to the DB even if they "connect/attach" in the connection string.

I read the documentation, and you are right, it still connects to the SQL Server Express service.

Thanks for correcting my mistake