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

Getting Field List to display in Reporting Services 2005

In VS2005 Report Designer how do you get the field list to display. In VS2003, The field list for the data sets shows on the left side of the screen under the toolbox without having to do anything. In 2005 I don't know how to make it appear at all. Any help, thanks in advance.

Ctrl-Alt+D or from the last item on the View menu, select Datasets.

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

The last item on my view menu is greyed out "property pages". Is that the item you are referring to? Datasets does not show anyplace.

When I click the Ctrl-Alt+D the system just displays the hourglass and does nothing.

|||Sorry Mary, I was too quick to respond. Your suggestion worked perfectly. I now have my dataset field list. How do I code a function for a report? I need to get info from a dataset and create a concatenated string. I know how to do it but I need to code the function in report designer.