Compute File CRC

Calculate the CRC for a file in the filesystem.

Download Chilkat Zip ActiveX (includes objects for .zip, .gz, .bz2, and .Z)

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @zipCrc int
    EXEC @hr = sp_OACreate 'Chilkat.ZipCrc', @zipCrc OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @crc int

    EXEC sp_OAMethod @zipCrc, 'FileCrc', @crc OUT, 'someFile.dat'
    DECLARE @hexStr nvarchar(4000)

    EXEC sp_OAMethod @zipCrc, 'ToHex', @hexStr OUT, @crc

    PRINT @hexStr
END
GO