As you probably know by now "Microsoft® Visual Studio® 2005 Team Suite Service Pack 1" is available for a while now.

The question:

In which order if any should you install Visual Studio 2005 SP1 in combination with Visual Studio Team Edition for Database Professionals?

The answer:

You will need to install or re-install Visual Studio SP1 after you installed Visual Studio Team Edition for Database Professionals.

Why?

Most components that are part of VS DB Pro are fine, since they never shipped before, but the Database Unit Testing functionality builds on top of the existing functionality from Visual Studio Team Test. So if you had the Team Test bits installed as part of Visual Studio Team Test or Visual Studio Team Suite, you need to install or re-install SP1 after you installed the VS DB Pro bits, to make sure you are using the latest and a consistent set of testing bits.

This is why our first service release will require and only work in combination with Visual Studio 2005 SP1.

What about the Vista?

If you are running on Vista you should install the "Visual Studio 2005 Service Pack 1 Update for Windows Vista Beta", however there are no shared binaries between this setup and the Visual Studio Team Edition for Database Professional bits, so you do not have worry about re-installing in this case.

SQL Server 2005 SP2?

The same is true with regards to SQL Server 2005 SP2, since there are no shared binaries, you have no installation dependency or ordering. Please see my previous post for more details (http://blogs.msdn.com/gertd/archive/2007/02/19/sql...)

I hope this helps keeping your installation sane,

-GertD