Tuesday, August 19, 2008

SQL Server 2000 - No wizards available in Enterprise Manager -> Tools


If your wizards select screen looks like this in SQL Server 2000, you have probably selected the SQL Server Group rather than a SQL Server or a specific database. The normal screen will appear if you select a database or a server.

Monday, June 9, 2008

SQL Server 2005 Menu items don't show up...

If you install SQL Server 2005 after installing Visual Studio 2005 or 2008 (with SQL Server Express), you may have a successful installation which leaves "Microsoft SQL Server 2005 -> Configuration Tools" as the only menu option.

At the time of this writing, I could find only one article on the net which offered a suggestion, here:
http://articles.techrepublic.com.com/5100-10878_11-6141894.html

You can see from the article that it requires you to remove all SQL Server 2005 pieces...

This is not necessary. All that is truly needed is to navigate to the setup.exe on the installation media and run the following at the command line:

setup.exe SKUUPGRADE=1

This saved me some time, and hopefully it will help someone else out there!

Transitioning to Front-End Development: My Journey into JavaScript

  For years, I’ve been deeply entrenched in the Microsoft stack, working extensively with SQL Server, Oracle Database, and even IBM DB2. Whi...