Help- Need to Practice SQL server with VS and only Win XP Home

[danofweaver]

How can I practice the use of SQL server without changing my
girlfriends laptop to XP Pro (which anyway I dont have)?
Using (unfortunately) Windows XP Home not Pro, Visual Studio 2005.
Trying to learn SQL server with asp, javascript, vbsrcipt and HTML-
new to this.
Headbutted the wall for a few hours trying to install SQL Server
properly. The long and short is no IIS with Win XP Home so doesnt seem
to work properly. I did manage to connect to Northwinds and publs DB
so can use them to learn but I need to be able to ceate own database.
Ie 3 tables.
For the moment I have created a table in Northwind which I will try to
fill with data
from a notepad file I have...
Dan

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

Dan,

According to the hardware and software requirements listed here:

http://msdn2.microsoft.com/en-us/library/ms143506.aspx

you can install SQL Server 2005 Express Edition with Advanced Services on XP
Home SP2. The only part of the product that will not install is Reporting
Services.

The Express Edition with Advanced Services is free and an excellent way to
learn SQL Server.

Kerry Moorman
"da*********@googlemail.com" wrote:

How can I practice the use of SQL server without changing my
girlfriends laptop to XP Pro (which anyway I dont have)?
Using (unfortunately) Windows XP Home not Pro, Visual Studio 2005.
Trying to learn SQL server with asp, javascript, vbsrcipt and HTML-
new to this.
Headbutted the wall for a few hours trying to install SQL Server
properly. The long and short is no IIS with Win XP Home so doesnt seem
to work properly. I did manage to connect to Northwinds and publs DB
so can use them to learn but I need to be able to ceate own database.
Ie 3 tables.
For the moment I have created a table in Northwind which I will try to
fill with data
from a notepad file I have...
Dan

[danofweaver]

Thanks Kerry, on further inspection I think this must have been one of
the things I tried- it seems to be installed on my computer though
calls itself "Microsoft SQL Server 2005" I am happy to hear that I
can theoretically get it to work... see my next query- if I can't
figure it I suppose I will uninstall everything and start again with
installing SQL express etc.

Thanks again,
D
On Feb 9, 11:33 am, Kerry Moorman
<[e-mail]:

Dan,

According to the hardware and software requirements listed here:

http://msdn2.microsoft.com/en-us/library/ms143506.aspx

you can install SQL Server 2005 Express Edition with Advanced Services on XP
Home SP2. The only part of the product that will not install is Reporting
Services.

The Express Edition with Advanced Services is free and an excellent way to
learn SQL Server.

Kerry Moorman

"[e-mail]" wrote:

How can I practice the use of SQL server without changing my
girlfriends laptop to XP Pro (which anyway I dont have)?
Using (unfortunately) Windows XP Home not Pro, Visual Studio 2005.
Trying to learn SQL server with asp, javascript, vbsrcipt and HTML-
new to this.
Headbutted the wall for a few hours trying to install SQL Server
properly. The long and short is no IIS with Win XP Home so doesnt seem
to work properly. I did manage to connect to Northwinds and publs DB
so can use them to learn but I need to be able to ceate own database.
Ie 3 tables.
For the moment I have created a table in Northwind which I will try to
fill with data
from a notepad file I have...
Dan

[danofweaver]

On Feb 9, 12:53 pm, "[e-mail]"
<[e-mail]:

Thanks Kerry, on further inspection I think this must have been one of
the things I tried- it seems to be installed on my computer though
calls itself "Microsoft SQL Server 2005" I am happy to hear that I
can theoretically get it to work... see my next query- if I can't
figure it I suppose I will uninstall everything and start again with
installing SQL express etc.

Thanks again,
D

On Feb 9, 11:33 am, Kerry Moorman

<[e-mail]:

Dan,

According to the hardware and software requirements listed here:

http://msdn2.microsoft.com/en-us/library/ms143506.aspx

you can install SQL Server 2005 Express Edition with Advanced Services on XP
Home SP2. The only part of the product that will not install is Reporting
Services.

The Express Edition with Advanced Services is free and an excellent way to
learn SQL Server.

Kerry Moorman

"[e-mail]" wrote:

How can I practice the use of SQL server without changing my
girlfriends laptop to XP Pro (which anyway I dont have)?
Using (unfortunately) Windows XP Home not Pro, Visual Studio 2005.
Trying to learn SQL server with asp, javascript, vbsrcipt and HTML-
new to this.
Headbutted the wall for a few hours trying to install SQL Server
properly. The long and short is no IIS with Win XP Home so doesnt seem
to work properly. I did manage to connect to Northwinds and publs DB
so can use them to learn but I need to be able to ceate own database.
Ie 3 tables.
For the moment I have created a table in Northwind which I will try to
fill with data
from a notepad file I have...
Dan

Kerry- sorted- was as simple as .\SQLEXPRESS for server connection!
Thanks