How and where should I create a mdf file if I installed a sql server 2005(Developer EditioN)

hi:

I am a newbie to sql server 2005 (developer edition). Now I installed both sql server and VS 2005 professional edition on my machine.

I just what to know how and where should I create a mdf file on my server or .net window project because I try to combine to it from a window application. Should I use the sql server management studio or the Visual Studio 2005 ? What is the generate steps to create one?

I am completely confused. Please help me, I cannot find related on line source.

Thank you, thank you

bigheadjj

That depends wheter you want to use a user instance with a SQL Server database or a SQL Server hosted instance. The Visual Studio Database can support both, whether a user or a server instance. Did you have the concept of a user instance or a server instance ? If not, I would suggest you reading the principles of that in the web.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Even if VS 2005 can connect to the server and create database files, I recommend that you use the SQL Server client tools (SSMS, sqlcmd, etc.) This gives you a good understanding of what is happening on the database side. Plus, using the SQL Server client tools, you can configure other database options which cannot be done using VS 2005|||

Jens

Thank you very much. I will start to read related principles as you suggested.

|||

bass_player

thank you for helping me. Your recommendation is very helpful.