Sql Server 2005 Installation. Can u tell me if we use MS Visual studio 2005 installed on the hard

Question

Can u tell me if we use MS Visual studio 2005 installed on the hard drive.nd we need to install sql server 2005 to integrate with MS Visual studio 2005.My pbm is if we install MS VS 2005, it automatically install express edition of sql server 2005.but it didnt have enterprise manager...nd can u tell me where i get sql server 2005 studio software nd sql server 2005 studio software(good version)?