Showing posts with label stuck. Show all posts
Showing posts with label stuck. Show all posts

Monday, March 26, 2012

Getting started with MSDE

I have no experience with MSDE and I am trying to learn how to start using it. I just installed MSDE 2000 release A and I am stuck and don't know what to do next. I heard that MSDE is only a database engine and you need to download tools/toolkits to creat
e databases and tables. Where can I get the necessary tools to start creating my database in MSDE?
Thanks.
-laura
Hi,
You can use the "SQL Server Web Data Administrator". It can be downloaded
from
http://www.microsoft.com/downloads/d...798-c57a-419e-
acbc-2a332cb7f959&displaylang=en
System Requirements for SQL Server Web Data Administrator is
Supported Operating Systems:
Windows 2000 Service Pack 4, Windows Server 2003, Windows XP
Web Data Administrator requires:
Microsoft SQL Server 7 SP2 or later
Microsoft .NET SDK or Microsoft Visual Studio .NET
Microsoft Internet Explorer 5.5 or later
Microsoft Internet Information Services (IIS) -- optional, a portable
web server* is also distributed with the project
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||If you are going to be doing much development, get the SQL Server
Developer's Edition. I gather it's currently only around $49 USD. You won't
find any value anywhere that compares with what you get for that.
If you aren't getting that and web isn't your style, we have a free personal
tool (MSDE Manager) at our site that might help.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"lmm" <anonymous@.discussions.microsoft.com> wrote in message
news:F4598769-B27F-488C-B859-9E46DBE344AA@.microsoft.com...
> I have no experience with MSDE and I am trying to learn how to start using
it. I just installed MSDE 2000 release A and I am stuck and don't know what
to do next. I heard that MSDE is only a database engine and you need to
download tools/toolkits to create databases and tables. Where can I get the
necessary tools to start creating my database in MSDE?
> Thanks.
> -laura

Friday, March 23, 2012

Getting Started SQL 2005

Can anyone help with REAL Fast Track links to Getting Started with SQL 2005 DB Design? I have loads of ideas on implementing databases but I'm stuck on where exactly to start from. No prior DB or programming experience but I possess remarkable aptitude.

>>No prior DB or programming experience but I possess remarkable aptitude

LOL - gotta love confidence.

Well, your first step is almost always a good book. I can't recommend any, the books I bought were SQL for programmers. You should read some beginner books on SQL and database design, and work from there. Remember, you can't do anything with a database unless you learn to drive a tool like Access, a programming language such as C#, or you're happy to type SQL directly into SQL Server for all your queries/inserts/updates.

|||Thanks a lot. Always 'knew' that the best way to start would be yo push Access to its limits. Hope using VB (2005) isn't a bad choice for a programming language. Figured I should start with VB before delving into C#. Once again, thanks a lot cos I'm darn serious about this .NET developer track. Resources on VB & C# programming are most welcome. Huge task ahead but I guess the 1st step is getting started!