vb pro 2005 and sql server 2005 Express edition

Are these compatible? I know that there is vb 2005 express edition, however I would like to find out of potential issues.
Would there be any problem if your database is a sql server express edition and your development tool is the vb pro 2005 (not vb 2005 express edtion)?
zachvaldezAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
the sql management tools come usually with sql express edition.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
they are compatible.
0
 
zachvaldezAuthor Commented:
what are the limitations as far as programming ? ADO.net,AsP.net-there would not be any issues I assume?
How about connecting issues?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you will have the limits of the SQL Express edition, but as far as development is concerned, you should not hit those limits, at least you should know them all.
there is no limit in ado.net or asp.net to connect to the full blown or the limited edition of sql server 2005
0
 
zachvaldezAuthor Commented:
that's what I want to know.
Can you create stored procedure and triggers with the express edition of sql?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>can you create stored procedure and triggers with the express edition of sql?
yes.
0
 
zachvaldezAuthor Commented:
After installing the SQl Server express edition , are there any tool that need to be installed to the machine?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>After installing the SQl Server express edition , are there any tool that need to be installed to the machine?
well, anything YOU need/want to.
0
 
zachvaldezAuthor Commented:
I heard about something like sql management.. that need to be installed--not sure?
0
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.