Monday, March 26, 2012

Getting started with Sql Server 2005....Create Database

Hi allI'm a newbie with Visual studio 2005 .Recently i installed it ,AFAIK sqlServer 2005also is shiped with vs2005.after installing vs2005 i have the following entries in my StartMenu/All Programms/1) Microsoft Sql Server 2005Configuration Tools sql Server Configuration Manager Sql Server Error and usage Reporting SQL Server Surface Area Configuration2) Microsoft Visual studio 2005 .... ......Apparently there isn't any ENTERPRISE MANAGER and query analyzer.?By the way in Visual studio IDE i noticed "Server Explorer" nexed to "Solution Explorer"but i didn't find any Database entry or "Create New Database" or some thing like this.!!!Could any one help me.? i want to Create Database, Tables,...Thanks in advance.Regards.

You're looking for Management Studio Express. Start with:

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

Jeff

|||

ZarrinPour:

Hi all I'm a newbie with Visual studio 2005 .Recently i installed it ,AFAIK sqlServer 2005 also is shiped with vs2005.after installing vs2005 i have the following entries in my StartMenu/All Programms/ 1) Microsoft Sql Server 2005 Configuration Tools sql Server Configuration Manager Sql Server Error and usage Reporting SQL Server Surface Area Configuration 2) Microsoft Visual studio 2005 .... ...... Apparently there isn't any ENTERPRISE MANAGER and query analyzer.? By the way in Visual studio IDE i noticed "Server Explorer" nexed to "Solution Explorer" but i didn't find any Database entry or "Create New Database" or some thing like this.!!! Could any one help me.? i want to Create Database, Tables,... Thanks in advance. Regards.

That depends on the edition of VS2005 if you have standard you can use the Advanced version of Express from the link below however profesional comes with the developer edition which means you need to copy the contents of your CD/DVD to your hard drive and rerun setup and choose add components or repair and add the management tools that gives you Management Studio. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/download/

sql

No comments:

Post a Comment