Which SQL Server - Microsoft SQL Server

Igor

On Win2000 or Win2003 you can use SQL Server 2000 Desktop Edition. On WinXP
you must use only SQL Server 2000 Developer Edition.
Which SQL Server 2005 I can use on WinXP?

Dec 29 '06 #1

Subscribe Post Reply

1323

Erland Sommarskog

Igor (ig**@nesalji.hr) writes:

On Win2000 or Win2003 you can use SQL Server 2000 Desktop Edition. On
WinXP you must use only SQL Server 2000 Developer Edition.

In fact you can use all editions save Standard and Enterprise Edition of
SQL Server 2000 on Windows XP. (I am not 100% sure about Workgroup Edition,
but it would not make sense if you could not.)

Which SQL Server 2005 I can use on WinXP?

All editions but Enterprise. That is, even Standard Edition.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Dec 29 '06 #2

dmarkle

I'm assuming here that you're a developer writing code on test
databases on your workstation. In that case, you'll want to use
Developer Edition. It includes just about all of the features and
optimizations inherent in Enterprise Edition, but runs on Windows XP.

-Dave
http://www.markleconsulting.com
Igor wrote:

On Win2000 or Win2003 you can use SQL Server 2000 Desktop Edition. On WinXP
you must use only SQL Server 2000 Developer Edition.
Which SQL Server 2005 I can use on WinXP?

Jan 8 '07 #3

Similar topics

Which way will take more memory?

by: Rabbit63 | last post by:

Hi: I want to show a set of records in the database table on the clicnt browser. I have two ways to do this (writen in JScript): 1.The first way is: <% var sql = "select firstname from...

ASP / Active Server Pages

Which SP3a for SQL 2000 Personal Edition?

by: gregs | last post by:

Hi folks, I need to know which EXE's of SP3 to install with SQL Server 2000 Personal Edition. From the Microsoft website: ...

Microsoft SQL Server

Which layer do you build the connection string?

by: H | last post by:

This is a question that has haunted me for quite some time. if you build a 4 tier database application where the 4th tier is the database server (MS SQL 2000), where do you build the connection...

.NET Framework

VB to C sharp anyone can point out which is the equivalent

by: Hai Nguyen | last post by:

I'm learning C sharp and do not like vb much. I'm creatiing a wepage using panel to test myself. I tried to use these code below, which is written in VB, and to transform them to c sharp but I got...

C# / C Sharp

Which hardware upgrades are more important

by: Jeff | last post by:

I know this is a difficult one to answer, but I am interested in opinions on what hardware upgrades would be recommended with the following. Access 2000 running in a split config, but all in...

Microsoft Access / VBA

Which is the better approach?

by: Rob Meade | last post by:

Hi all, I have a databse which I'm pulling the data from for my ASP page. I have 4 tables, Course, Feature, Objective, and PreRequisite. The last three all contain a course product code and a...

ASP / Active Server Pages

When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030.

by: alingsjtu | last post by:

Hello, every body. When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected...

DB2 Database

To connect to SQLServer 2005 database of a pc which is in domain from a pc in workgrp

by: smithaanna | last post by:

Hi, How can i connect to the sql server database(installed microsoft visual 2005 professional edition in which sql server 2005 express edition)a pc which is XP Professional SP2 and is in a...

Microsoft SQL Server

Which Is The Better Approach To Working With Javascript?

by: Patient Guy | last post by:

Which is the better approach in working with Javascript? 1. Server side processing: Web server gets form input, runs it into the Javascript module, and PHP collects the output for document prep....

PHP

Display .htm files content in .aspx page control

by: shashi shekhar singh | last post by:

Dear sir, I have a word document file contains text and images, now i have saved it as a web page and wants to display it on browser , using , string str=directory.getfiles("");...

ASP.NET

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

by: isladogs | last post by:

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA