SQL Server Express and Management Tool

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Free FrontPage Templates

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

SQL Server Express and Management Tool

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Community >> OutFront Discoveries >> SQL Server Express and Management Tool

Page: [1]


mar0364 Posts: 3221 Joined: 4/5/2002 From: Florida, US Status: online	SQL Server Express and Management Tool - 6/1/2006 21:42:24 http://msdn.microsoft.com/vstudio/express/sql/ Has anyone downloaded this and is using it succesfully with FP or DW etc. I'm tempted to try it but not sure. _____________________________ Easy Web “Stay committed to your decisions, but stay flexible in your approach.”


mar0364 Posts: 3221 Joined: 4/5/2002 From: Florida, US Status: online	RE: SQL Server Express and Management Tool - 6/7/2006 7:55:50 This works very nicely with FP, DW and of course Expression. Getting Enterprise Manager for free makes life allot easier. This is a much more intuitive version of Enterprise Manager then 2000. _____________________________ Easy Web “Stay committed to your decisions, but stay flexible in your approach.” (in reply to mar0364)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: SQL Server Express and Management Tool - 6/7/2006 13:35:25 I've been checking it out but some things it's not very intuitive to do: try importing a spreadsheet. It's pretty painful (for me anyways) to do that 1 task. Got any hints? It looks like I need to create a table and then copy and paste to it but that just seems wrong to me - there must be a 'better' way. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to mar0364)


mar0364 Posts: 3221 Joined: 4/5/2002 From: Florida, US Status: online	RE: SQL Server Express and Management Tool - 6/7/2006 13:54:09 What I did was use the Upsize wizard in Access and that worked fine. I'm dealing with some rights issues now. I know it seems like going around your A**hole to get to your thumb but you could save it as an mdb and upsize it. Thanks! Rich _____________________________ Easy Web “Stay committed to your decisions, but stay flexible in your approach.” (in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: SQL Server Express and Management Tool - 6/7/2006 14:15:11 quote: could save it as an mdb and upsize it I guess that's the way then. It just bugs me when they take a function away and call it progress. Especially functions that I use all the time. With Enterprise Manager, I could import directly from a CSV/XLS file. I guess that's progress for you. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to mar0364)


mar0364 Posts: 3221 Joined: 4/5/2002 From: Florida, US Status: online	RE: SQL Server Express and Management Tool - 6/7/2006 14:25:28 I'm convenced there is a department at MS setup just to do agrivating little things like this. I hate them/no I love them. Well that's how it goes. LOL _____________________________ Easy Web “Stay committed to your decisions, but stay flexible in your approach.” (in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: SQL Server Express and Management Tool - 6/9/2006 14:22:45 It is too bad. It looked so promising. I had to drop back to ENterprise Mangler last night to do some stuff that I just could not figure out in Express; simple UPDATE queries no less just had me baffled. Everything I tried just did not work - I even had full SA privs and couldn't do squat. 15 minutes later in EM and my work was done. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to mar0364)


mar0364 Posts: 3221 Joined: 4/5/2002 From: Florida, US Status: online	RE: SQL Server Express and Management Tool - 6/9/2006 14:49:23 If you right click a table one of the options is a generic update, delete or insert statement for that particular table. What does not kill you will make you better. < Message edited by mar0364 -- 6/9/2006 15:08:10 > _____________________________ Easy Web “Stay committed to your decisions, but stay flexible in your approach.” (in reply to rdouglass)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: SQL Server Express and Management Tool - 6/9/2006 17:02:11 quote: What does not kill you will make you better. However those UPDATE etc. statement areas just would not work for me no matter what I tried. I di dsee them and intuitively I know what they do. I spent 2 hours trying to get the stupid thing to update 1 field based on a value in a related table. Never could get it to do it. Like I said, 15 minutes in EM. I know I'm just under-trained on this thing. _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to mar0364)


mar0364 Posts: 3221 Joined: 4/5/2002 From: Florida, US Status: online	RE: SQL Server Express and Management Tool - 6/9/2006 17:09:30 Yea its tough learning these things. The kicker is once we learn they will change it. _____________________________ Easy Web “Stay committed to your decisions, but stay flexible in your approach.” (in reply to rdouglass)


yb2 Posts: 653 Joined: 1/30/2006 Status: offline	RE: SQL Server Express and Management Tool - 6/10/2006 3:41:45 I've spent a year learning .Net v1.1 and now everything is 2.0 and by the time I've worked out the changes to that I'm sure they'll be on version 3! (you can actually start using 3, there are pages somewhere that show all the work going into it) I like the new Management Studio though, I think it's a really nice mix of Query Analyser and Enterprise Manager. I especially like the Solutions and Projects for keeping queries organised. That is a real god send (for me). So you don't end up looking like your avatar RD (unless that's really is a photo of you) UPDATE myTable set FirstField = m.FirstField + r.SecondField FROM myTable m INNER JOIN RelatedTable r ON m.Whatever = r.Whatever WHERE m.Id = 50 _____________________________ it is natural for people not to see one's own faults, and to exaggerate other people's faults and failings. Currently listening to: L'Enfer Des Formes by Stereolab (in reply to mar0364)