Home All Groups Group Topic Archive Search About

SQL Express Questions

Author
17 Dec 2006 5:45 PM
Dennis
Someone tell me if I am understanding SQL Express correctly:

1) SQL Express is free and can be installed on any Windows XP operating system

2) SQL Express can be accessed from VB.Net 2003 just like any SQL database


--
Dennis in Houston

Author
17 Dec 2006 6:01 PM
DesCF
I happen to be reading a section in a book on SQL Server 2005.  It works 
with Windows 2000, XP, and 2003.  It requires the .NET Framework 2.0 to be 
installed on it's host computer.




On Sun, 17 Dec 2006 17:45:01 -0000, Dennis 
<Den***@discussions.microsoft.com> wrote:

> Someone tell me if I am understanding SQL Express correctly:
>
> 1) SQL Express is free and can be installed on any Windows XP operating 
> system
>
> 2) SQL Express can be accessed from VB.Net 2003 just like any SQL 
> database
>
>



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Author
17 Dec 2006 6:06 PM
Plamen Ratchev
Hi Dennis,

The answer to both questions is yes, with a note. For Windows XP it does
require SP2. Also, you need to install .NET Framework 2.0.

System Requirements:
http://www.microsoft.com/sql/editions/express/sysreqs.mspx

Overview:
http://msdn.microsoft.com/vstudio/express/sql/

SQL Server 2005 Express Home:
http://www.microsoft.com/sql/editions/express/default.mspx

Regards,

Plamen Ratchev
http://www.SQLStudio.com


Show quoteHide quote
"Dennis" <Den***@discussions.microsoft.com> wrote in message
news:E0A051F0-1F98-4B7C-91EF-E0736E5700FD@microsoft.com...
> Someone tell me if I am understanding SQL Express correctly:
>
> 1) SQL Express is free and can be installed on any Windows XP operating
> system
>
> 2) SQL Express can be accessed from VB.Net 2003 just like any SQL database
>
>
> --
> Dennis in Houston
Author
17 Dec 2006 6:09 PM
Robinson
Yes and yes.

But remember limitations: CPU, Memory Utilisation, Maximum DB size.
Author
17 Dec 2006 6:37 PM
Cor Ligthert [MVP]
Robinson,

> But remember limitations: CPU, Memory Utilisation, Maximum DB size.
For the installation there is no Maximum DB size, there is a Maximym per
database (it can be more) to use it.

Dennis wrote
>2) SQL Express can  be accessed from VB.Net 2003 just like any SQL database

What in my opinion can be seen as just like any SQL 2005 databaseserver.

Just as well to inform Dennis of course.

Cor


Show quoteHide quote
"Robinson" <b**@bbb.com> schreef in bericht
news:edWdnQm5u490GhjYnZ2dnUVZ8sG3nZ2d@giganews.com...
> Yes and yes.
>
> But remember limitations: CPU, Memory Utilisation, Maximum DB size.
>