Getting Started in SQL Server 2005
-
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.
-
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 -
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
Does anyone know where I can obtain SQL Server 2005 Enterprise /Developer edition Beta 2?Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply