Re: SQL SERVER 6.5 on XP Home

From: Weaver (we.aver_at_verizon.net)
Date: 05/19/04


Date: 19 May 2004 09:34:47 -0700

Thanks for all the responses. I have looked into MSDE 2000 and the
purchase of SQL SERVER 2000 Developer Edition. Can anyone confirm
that MSDE comes with an environment for developing stored procedures?
Although this seems rather obvious I don't see that it is explicitly
included anywhere in the MS documentation on the product.

One of the reasons that I wanted to get my old 6.5 running again (I
had been using it on an NT machine) is that it included some
absolutely marvelous examples of stored procedures. They weren't
examples, really, they were the actual utility procedures that did a
lot of the backbone work of the product. I haven't yet seen any
better, well written and well documented, stored procedures. Maybe I
haven't looked hard enough.

Again, thanks for the help. I'm leaning toward the use of SQL SERVER
2000 Developer Edition at this point. The cost is minimal and with it
I will get the use of MSDE for desktop deployment. Hopefully I will
get the stored procedures as well!



Relevant Pages

  • Re: What clients to use with Developer version?
    ... expressed that MS Access was not intended to be used with either MSDE, ... nor SQL server 2000 - a statement which contradicted in many Microsoft ... >off the developer edition of SQL Server is licensed as a development tool ... >> and our customer users, since we will not be supporting the ...
    (microsoft.public.sqlserver.clients)
  • Re: Can I Upgrade
    ... Developer Edition of SQL Server can not be used as a production server. ... technically you can (even though I don't really remember technically if you can upgrade from MSDE 2000 to Developer Edition 2000); however it's against the license agreement. ... And here I'm making a list from start to end to install and configure MSDE for remote connections: ...
    (microsoft.public.sqlserver.setup)
  • Re: SOMEONE PLEASE ANSWER. NEED ADVICE. Was: Is MSDE what I need?
    ... i ordered SQL Server Developer Edition. ... Do i program to MSDE or SQL Server? ... Euan Gardenwrote: ...
    (microsoft.public.sqlserver.msde)
  • Re: access as frontend to backend sql 2000
    ... Do you find that you need other tools besides ADE and SQL DE for such an environment? ... SQL Server Developer Edition includess development tools, especially Enterprise Manager and Query Analyzer that are indispensable. ... Improves productivity working with MSDE, and online help you cannot get along without. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: sql debugging
    ... > SQL Server setup or contact database administrator. ... > Can sql debugging be used with MSDE? ... You certainly can debug Stored Procedures in MSDE using VS.Net2003. ...
    (microsoft.public.sqlserver.msde)