VB.net app using SQL Server

I'm working on a VB.net app that uses SQL Server 2000 as it storage utility.  If I wanted to distribute this application to PC's as a single user application and they(the user) did not have an instance of SQL Server, what would I need to do?   Is there a way to include an "instance" of SQL Server?  

I hope I've explained this well enough...
Who is Participating?
checooConnect With a Mentor Commented:
MSDE is the right product for you.

check out the details at the following location http://www.microsoft.com/sql/msde

register for distribution rights of MSDE at http://www.microsoft.com/sql/msde/howtobuy/redistregister.asp

MSDE FAQ http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp

create MSDE setup project http://support.microsoft.com/default.aspx?scid=kb;en-us;325004
cyberdevil67Connect With a Mentor Commented:
Hi tobin46,

  Look at the MSDE 2000 which is the MS Database Engine for desktops... MS website has all the information as does the MSDN for setting and deploying this with applications to desktops, and is what I would recommend doing.

Arthur_WoodConnect With a Mentor Commented:
in answer to your original question, NO you cannot distribute an 'Instance" of SQL Server.  MSDE is the correct alternative, as it is a FREE desktoip version of SQL Server, so you can load ALL of your stored procedures, and Tables from YOUR instance of full SQL Server, into the local instance of MSDE, and all will be right with the world.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.