Delicious

Merry Christmas to all

Yesterday I sold my  6680 at ebay.ph, and got a brand new Motorola L7 for me and Motorola L6 for my brother Bryan.

At last, I have already registered my official domain name for my weblog. I have past blog and I will try to figure out how will I transfer my archives here.

I have just installed Visual Studio 2005 Professional Edition, SQL Server 2005 Developer Edition running in x86 operating bit systems .

Anyway, I first installed Visual Studio followed by the SQL Server 2005. Since I’m only running a SQL Developer Edition which does’nt have the Enterprise Manager like in SQL Server 2000. Then I now want to use the SQL Server Management Studio to administer a database I have running on a website. The SQL Server Management Studio in SQL Server 2005 is equivalent to Enterprise Manager and Query Analyzer in SQL Server 2000. At first I’m so confused in it, but upon reading and searching in MSDN…all my questions was absolutely answered.I really had a hard time installing my SQL Server 2005 with SQL Management Studio. The problem is where do I find this SQL Server Management Studio? I guess that I installed the Visual Studio first. And in that case, I likely got a copy of SQL Server Express Edition installed by the Visual Studio. It has a subset of the SQL Tools that need to be upgraded to the Developer Edition tools.

I got the solution to my problem I went to Add/Remove Programs, selected “Remove” on SQL Server 2005, then in the dialog that comes up next, select to remove the “Workstation components…” and the “SQLExpress Instance…”. Then after that is finished, restart setup and reinstall the tools.

When I go through the UI for SQL Server 2005 Setup, at some point I came to a “Existing Components” dialog with a checkbox asking if I want to install the “Workstation Components, Books Online and Development Tools”. I Check that box, then continue…

Once I finished installing…Boom! I made it! I found in the Start Menu folder all these “Microsoft SQL Server 2005″ and another folder inside that called “Configuration Tools”, “Analysis Services”, “Performance Tools” “SQL Server Business Intelligence Development Studio”, “SQL Server Management Studio” and “Documentations and Tutorials”.