Hi, I've installed:

Microsoft Visual C# 2005 Express

Microsoft Visual Web Developer

SQL Server 2005 Express


How am I supposed to use sql server?
Can I use it from both C# 2005 Express and VWD?

I haven't got a clue whats going on, I can't even uninstall sql server.
Is there any instructions that are clear and actually work.

Thanks

Yes you can, to create databases and connect to them you go view -> server explorer

check microsofts site, under the express section, there are loads of video tutorials

Thanks I see it.

Now I need a database to try with it.
If you have one, could you email it to me?

colin.shuker@tiscali.co.uk

Or point me to where I can find one.

Thanks

You cannot email a database. See the same site for tutorials for creating a database its pretty easy.

actually you can mail SQL server databases there .MDF files

The mailing option was introduced in the SQLSERVER 2005 i guess.. ive been working on 2000.

Yes, one can detach a database, mail across the .MDF and .LDF files and these can then be attached as database at the other end.

Thats why microsoft give you a built in database (northwind) so you dont have to get one to start off.

They have an SQL version of northwind?
I thaught it was an access thing?

thats cool

have you guys used SQL express?

thats much easier to transfer database IMHO - i export my databases and send them as part of the installer along with my Visual Studio / Visual Web Developer applications.

We use both depending on the app. I have SQL for web apps, we also code for company sql databases and we use SQL express for some small desktop apps but mainly use SQL express so our users can work offline and then it will sync back to a main SQL Database when they are connected to the net

yeah, i use Express for development

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.