New to SQL Server -- sql server new users

Andrew Watt [MVP]
5/17/2006 12:00:00 AM

Hi,

All editions of SQL Server 2005 except Enterprise will install on
Windows XP Pro SP2.

One gotcha to watch out for is that you can't have both (full) SQL
Server Management Studio and SQL Server Management Studio Express on
the same machine. That's a choice you should make up front.

To learn SQL Server 2005 I suggest the choice lies between

1. SQL Server 2005 Developer Edition (costs about $50 at Amazon.com
etc)

2. SQL Server 2005 Express Advanced Edition (free)

If you're starting now with Express get the SP1 download from
http://msdn.microsoft.com/vstudio/express/sql/download/. Read the
infomration about what's in the different downloads carefully to make
the appropriate choice for you.

Andrew Watt MVP

On Tue, 16 May 2006 17:22:25 -0400, "Jan Il"
[quoted text, click to view]

Jan Il
5/17/2006 10:12:37 AM

Hi Andrew :-)

[quoted text, click to view]

Thank you very much for the additional information. I did read that is said
if you already had one version of the SQL installed to uninstall it before
using the advanced version. I didn't have any so I had an easy choice. I
got the Express version with the additional tools and such, and also
downloaded the samples and On-Line Books. I have not installed anything
yet, I wanted to wait until I found out more about what to be aware of
before I installed, just in case I needed to make any adjustments, or may
have made the wrong choice.

Jan :)

[quoted text, click to view]

Jan Il
5/17/2006 10:18:23 AM

Hi Andrew :-)

What would you say the level of difficulty is the SQL, and what is the
bottom line difference between Access and SQL? I ask as I need to know if
this is something that my potential client's experience might even be close
enough to tackle this at this point.

Jan :)

Jan Il
5/17/2006 1:19:40 PM

Hi Andrew :-)

Thank you for the additional information. I will take it slow and make sure
I read and follow all directions carefully. If I run into problems, I will
start a new thread. :-)

Jan :)
MVP/Windows IE [DTS/AumHa]

[quoted text, click to view]

Andrew Watt [MVP]
5/17/2006 4:08:57 PM

On Wed, 17 May 2006 10:12:37 -0400, "Jan Il"
[quoted text, click to view]

Installation should be straightforward, assuming you didn't have any
beta software for the .NET Framework etc installed previously. Just
take your time and read the screens in the Setup utility carefully.

From what you said previously it sounds a good choice. And the price
is right! :)

If you have any problems with installation (it's unlikely) I suggest
you start a new thread.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : New to SQL Server