SQL Server compatability with XP Professional

I'm new at this and only trying to learn. If I purchase the SQL Server 2000 for my home office can I run SQL in server mode on my Dell (500mb 40gb) notebook on it's XP Professional operating system?

Also, I assume when an application reuires a SQL Data File it loads it into memory, opens it and closes it while still in memory. The file is returned to disk at the close of the application. Is this correct?


Comments

  • : I'm new at this and only trying to learn. If I purchase the SQL Server 2000 for my home office can I run SQL in server mode on my Dell (500mb 40gb) notebook on it's XP Professional operating system?
    :
    : Also, I assume when an application reuires a SQL Data File it loads it into memory, opens it and closes it while still in memory. The file is returned to disk at the close of the application. Is this correct?
    :
    :
    :
    SQL Server 2000 Personal Edition will run on XP Pro. If you want to check out all of the system requirements go to http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp.

    SQL Server runs a service. Any database files will be open while the service is running whether any external application is accessing the database or not. SQL Server will cache any data queried or modified into RAM. The amount of RAM it uses can be configured.
  • : : I'm new at this and only trying to learn. If I purchase the SQL Server 2000 for my home office can I run SQL in server mode on my Dell (500mb 40gb) notebook on it's XP Professional operating system?
    : :
    : : Also, I assume when an application reuires a SQL Data File it loads it into memory, opens it and closes it while still in memory. The file is returned to disk at the close of the application. Is this correct?
    : :
    : :
    : :
    : SQL Server 2000 Personal Edition will run on XP Pro. If you want to check out all of the system requirements go to http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp.
    :
    : SQL Server runs a service. Any database files will be open while the service is running whether any external application is accessing the database or not. SQL Server will cache any data queried or modified into RAM. The amount of RAM it uses can be configured.
    :
    Thanks for your help... Ron
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion