Installing ClearCase Remote Client for Visual Studio 2008 and 2010

Here is the guide to install ClearCase Remote Client 7.0.1 for Visual Studio 2008.

  1. If Visual Studio 2005 wasn't already installed, you have to create in the registry, under the node HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\8.0, a string with name InstallDir and value the install path of Visual Studio 2008, tipically C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE.
  2. After that, install the client, downloaded from https://YourCCRCServer/ccrc/update/ccrcvsi_win32.zip
  3. Download the updates to the registrations specific for Visual Studio 2008 from ftp://ftp.software.ibm.com/software/rational/clearcase/7.0.1/VS2008_support/CC-CQ-VS2008.zip for 32 bit and from ftp://ftp.software.ibm.com/software/rational/clearcase/7.0.1/VS2008_support/CC-CQ-64_BIT-VS2008.rar for 64 bit.
    Extract the zip file, open with Notepad the file reg_VS2008.bat and change the initial assignements so that CC_for_VS=0 and CQ_for_VS=0 (but keep CCRC_for_VS=1).
  4. From the command prompt, go the folder with the extracted files and execute the file reg_VS2008.bat.
    If all went fine, from Visual Studio 2008 the top menu ClearCase should appear.

And here are the adjustments necessary for Visual Studio 2010.

  1. Download and extract the file from ftp://ftp.software.ibm.com/software/rational/clearcase/7.0.1/VS2010_support/CC_7.0.1_VS2010.zip.
  2. Modify the reg_VS2010.bat file so that CC_for_VS=0 and CQ_for_VS=0 (keep CCRC_for_VS=1).
  3. From the command prompt, go to the folder with the extracted files and execute the file reg_VS2010.bat.
    If all went fine, from Visual Studio 2010 the to menu ClearCase should appear.

Order of Installation of SharePoint Patches

The general rule is that you have to install language pack and service pack according the chronological order they have been released (so that: “language pack”, “service pack 1”, “language pack of service pack 1”), keeping in mind that even if MOSS 2007 included WSS 3.0, both its service packs and its language packs don't.

So the order of installation is:

  1. WSS 3.0 language pack Italian
  2. MOSS 2007 language pack Italian
  3. WSS 3.0 service pack 1 English
  4. MOSS 2007 service pack 1 English
  5. WSS 3.0 language pack Italiano service pack 1
  6. MOSS 2007 language pack Italiano service pack 1
  7. WSS 3.0 service pack 2 English
  8. MOSS 2007 service pack 2 English
  9. WSS 3.0 language pack Italian service pack 2
  10. MOSS 2007 language pack Italian service pack 2

I add here recent packages:

  1. WSS 3.0 service pack 3 English x64 (here x86)
  2. MOSS 2007 service pack 3 English x64 (here x86)
  3. WSS 3.0 language pack Italian service pack 3 x64 (here x86)
  4. MOSS 2007 language pack Italian service pack 3 x64 (here x86)

Get Command-Line Output from SQL Server 2005

Sometimes, from SQL Server you need to execute a command line application and retrieve its output in a variable.

When you want to to this, you have to consider:

  1. Enabling the execution of the xp_cmdshell stored procedure
  2. Saving the output of the command (maybe more lines) in a temporary table
  3. Taking the first row a putting it in a variable

Finally, here is a complete example. In this case I take the first user in Active Directory whose distinguished name starts with Damiano:

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO
CREATE TABLE #TEMP (
    LINE nvarchar(4000)
)
INSERT INTO #TEMP EXECUTE master..xp_cmdshell 'dsquery user -name Damiano*'
GO
EXEC sp_configure 'xp_cmdshell', 0
GO
RECONFIGURE
GO
EXEC sp_configure 'show advanced options', 0
GO
RECONFIGURE
GO
DECLARE @MYVAR nvarchar(512)
SELECT TOP 1 @MYVAR = LINE FROM #TEMP
DROP TABLE #TEMP