Update

Suppose you have a column in Table1 that you need to update with data from another column in Table2. Let’s do it!

As Microsoft recently released Service Pack 2 for Office 2007 suite, it is a good idea to add the update files to the package so it can be installed during the installation. So, first of all we have to download the SP2 executable file from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=b444bf18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en (see Visio and Project information at the end…

Few months ago I had an interesting problem at a client site that took me a while to resolve. So I want to post it here, maybe it will help others… After a successful upgrade from SMS 2003 to SCCM 2007 SP1, I configured software update point, synchronized with Microsoft update to get the list…