I have some questions
1) lets say that im developing a asp.net site using VS 2008 , how do i use sql server 2005 as the database
2) I have using MS-ACCESS as the database before and it was easy , all had to do was to create a .mdb file in APP_data folder!! now how to do it with SQL
3)Is it like rightclick on "data connections" in server explorer and create a sql server database in app_data folder or is there a different way that i should follow??
4) why is sql server management studio used for ?
Thanks in advance