Post reply

Getting Started in SQL Server 2005

  • January 26, 2005 at 11:01 am

    #164444

    Setting up SQL Server 2005: Go easy on me, I spent too long in a totally MacIntosh environment and I’m still learning in the Windows 2000 world.  I've been performing DBA duties using SQL Server 2000 for around a year, mostly creating stored procedures and queries and performing data conditioning using T-SQL, so lots of work in Query Analyzer, but not a lot of admin duties (such as installation).  I've downloaded from Microsoft and installed "SQL Server 2005 Express Edition Beta 3".  I've hopefully jumped through all the appropriate hoops regarding having .NET framework 2.0, and all other system requirements.  The installation completed with no visible errors.  My Programs menu currently shows "Microsoft SQL Server 2005", and the submenu shows "Microsoft SQL Server Engine Samples, SQL Server 2005 Books Online (Abridged), SQL Server Express Books Online, and SQL Computer Manager".  Seems logical to open the "SQL Computer Manager" as my first step.  The question is where do I go from here?  How to attach databases?  How to write T-SQL code as I do in the Query Analyzer in SQL 2000?  I've looked in the above-mentioned BOL but haven't found a good "getting started" link.

    Thanks in advance.

  • January 26, 2005 at 12:24 pm

    #539220

    A good starting point would be to install SQL Server 2005 Enterprise / developer edition Beta 2. Express is not that high-end.

    Once you do that, SQL Serv er Management Studio would provide you with all the functionality.

     

    Kindest Regards,

    M Suresh Kumar

  • January 26, 2005 at 3:15 pm

    #539246

    A search on the MS Download Center for "SQL Server 2005" turns up nothing except the Express version.    Does anyone know where I can obtain SQL Server 2005 Enterprise /Developer edition Beta 2?

  • January 27, 2005 at 1:47 am

    #539280

    I *think* the most widely available way of getting it is through being a TechNet subscriber. I'm not sure if its on MSDN yet.

    HTH.

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

  • January 27, 2005 at 10:32 am

    #539395

    Thank you for the input, Suresh and Jamie....

  • February 2, 2005 at 12:11 am

    #540088

    That's correct, for now you need to have a MSDN subscription to get a hold of the full version.  Beta3 when released will be available for everyone.

    Preview 1 of Express Manager is at http://www.microsoft.com/downloads/details.aspx?familyid=8F92556A-6C3B-47D2-9929-ECDC5A4D25AE&displaylang=en

    (at the bottom of the SSX download page)

    This will give you a graphical interface into the server so you can write T-SQL.  Not sure what version of SQL Express you have, but if you want the suite of what works together, here is the downloads for the framework, express, and express manager:

    1. .NET FX 2.0.40903 is at http://download.microsoft.com/download/9/A/4/9A47D72B-9D98-46CC-87F3-B92E97888E4B/dotnetfx.exe

    (right at the top of the December CTP download page)

    2. SQL Server 2005 Express 9.00.0981 is at http://www.microsoft.com/downloads/details.aspx?FamilyId=66120BE8-826A-482A-8264-B1836F28FD79&displaylang=en

    3. Preview 1 of Express Manager is at http://www.microsoft.com/downloads/details.aspx?familyid=8F92556A-6C3B-47D2-9929-ECDC5A4D25AE&displaylang=en

    (at the bottom of the SSX download page)

    --
    Thx, Niko
    SQL Setup Test Team

  • February 2, 2005 at 5:04 pm

    #540284

    Many thanks, Nikop!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply