Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 9th, 2003, 11:57 AM
Registered User
 
Join Date: Jun 2003
Location: South Lyon, MI, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Purchasing SQL Server

I'm trying to set up a development environment on my home machine and I'd like to get a copy of SQL Server since I use it at work. I was told that it came as a developers copy with some other software.

Does anyone have an recommendations?

Regards
Reply With Quote
  #2 (permalink)  
Old June 9th, 2003, 12:07 PM
Registered User
 
Join Date: Jun 2003
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SQL Server Developer addition is bundled (along with various other software) with Visual Studio .Net 2003 Ent Developer or Ent Architect editions. See Microsoft website for details.

Alternatively for the completely free option you could use MSDE - from a development perspective I hear it's identical to SQL Server (just isn't scalable). Never used it personally though.

Make sure you have the right operating system on your home PC for the version of SQL Server you obtain - for instance if you were running Win 98 you could only install SQL Server 2000 Personal Edition. MSDE should run on anything.
Reply With Quote
  #3 (permalink)  
Old June 9th, 2003, 01:24 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

MSDE is indeed SQL Server 2000. It is constrained to a 2GB maximum database size and 5 simultaneous connections.

It also does not come with the graphical managment tools like Enterprise Manager and Query Analyzer.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Reply With Quote
  #4 (permalink)  
Old June 9th, 2003, 01:59 PM
Registered User
 
Join Date: Jun 2003
Location: South Lyon, MI, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That was the thing about MSDE. What do I use to build the tables or queries with the GUI tools? I assumes, or seems to, that I have developed the databasee somewhere else and ported it over to let me distribute a database with my software package.
Reply With Quote
  #5 (permalink)  
Old June 9th, 2003, 07:24 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Sydney, NSW, Australia.
Posts: 215
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can install the client tools from your full version and use them with MSDE.

regards
David Cameron
Reply With Quote
  #6 (permalink)  
Old June 9th, 2003, 07:50 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:Originally posted by mr_federalist
 That was the thing about MSDE. What do I use to build the tables or queries with the GUI tools? I assumes, or seems to, that I have developed the databasee somewhere else and ported it over to let me distribute a database with my software package.
Note also that MSDE does come with ISQL.EXE which is a command line tool that will execute queries. These queries can be entered on the command line or be executed from a text file. In theory, you can do everything you need to do with this tool, albeit not nearly as easily as with the GUI tools.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
Reply With Quote
  #7 (permalink)  
Old June 11th, 2003, 09:45 AM
Registered User
 
Join Date: Jun 2003
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What I use at home is :-

1. MSDE (downloaded from Microsoft, free)
2. SQL Server evaluation editon (downloaded from Microsoft, free)

.BUT.

I only installed the Client Tools from the SQL Server download. This gives me GUI access (Enterprise Manager, Query Analyzer, etc) to MSDE without having to purchase SQL Server of get hold of any disks.

Works a treat.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conflict in SQL Server 2000 and SQL Server 2005 ayan.mukherjee SQL Language 0 June 30th, 2008 03:34 AM
SQL Server Reg. SQL Server does not exist error Arsi SQL Server 2000 1 June 11th, 2008 11:20 AM
migrating from sql server 2000 to sql server 2005 abinashpatra SQL Server 2005 2 December 1st, 2006 03:45 PM
Purchasing Crystal Reports sqldeveloper Crystal Reports 2 November 30th, 2004 05:12 PM
Purchasing SQL Server golfvilla BOOK: ASP.NET Website Programming Problem-Design-Solution 6 January 7th, 2004 08:04 PM



All times are GMT -4. The time now is 04:06 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.