SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Launching SQL Server 2005
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ed123
Starting Member

6 Posts

Posted - 08/05/2006 :  14:57:21  Show Profile  Reply with Quote
I installed Microsoft SQL Server 2005 Express. However, all that shows up in my "Start" menu is "Configuration tools." How do I open the application where I can start coding?

Edited by - ed123 on 08/05/2006 15:39:18

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/05/2006 :  16:30:30  Show Profile  Visit nr's Homepage  Reply with Quote
You don't get a gui with express.
see
http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

ed123
Starting Member

6 Posts

Posted - 08/05/2006 :  16:36:22  Show Profile  Reply with Quote
Then how do I write an SQL code with Express?
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/05/2006 :  16:56:17  Show Profile  Visit nr's Homepage  Reply with Quote
Look at the link.
it's sql server management studio express.

With msde you would use osql and could still use that.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

ed123
Starting Member

6 Posts

Posted - 08/05/2006 :  17:13:50  Show Profile  Reply with Quote
Sorry nr, I'm a beginner with this. Can you please explain to me the difference between server management studio express and Server 2005 Express. Also, what are msde and osql?
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/05/2006 :  17:19:06  Show Profile  Visit nr's Homepage  Reply with Quote
Msde is the v2000 equivalent of express.
osql is a command line interface to sql server.
Management studio is the the qui for v2005.
Management studio express is the free equivalent for sql server express.
sql server 2005 express is the (cut down) sql server database engine.

Try using google and the microsoft site.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

ed123
Starting Member

6 Posts

Posted - 08/05/2006 :  17:26:53  Show Profile  Reply with Quote
So basically I have to install both management studio express and server 2005 Express? Why wouldn't they put them both in one package?
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/05/2006 :  17:28:22  Show Profile  Visit nr's Homepage  Reply with Quote
You maybe should ask why they give away management studio express - they never did for v2000.
Or why don't they give away the full version.
What about all the people who just want the database engine? Why force them to download the gui?
No you don't need to install them both - only if you want them both.

It's free - be grateful for what you get.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Edited by - nr on 08/05/2006 17:30:58
Go to Top of Page

ed123
Starting Member

6 Posts

Posted - 08/05/2006 :  18:26:27  Show Profile  Reply with Quote
what's the difference between express and the one you have to pay for?
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/05/2006 :  18:42:19  Show Profile  Visit nr's Homepage  Reply with Quote
How did you find out about express
see
http://www.microsoft.com/sql/prodinfo/overview/default.mspx

Try using google.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

ed123
Starting Member

6 Posts

Posted - 08/05/2006 :  19:01:08  Show Profile  Reply with Quote
OK Thanks nr. You've been very helpful.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000