Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Best Way to Calculate Age

    That one works flawlessly.

    DECLARE @DateOfBirth VARCHAR(10)

    SET @DateOfBirth = '1960-03-07'

    print YEAR(GETDATE()) - YEAR(@DateOfBirth) - CASE WHEN MONTH(GETDATE())*31 + DAY(GETDATE()) >= MONTH(@DateOfBirth)*31 + DAY(@DateOfBirth) THEN 0 ELSE 1 END

  • RE: Intermitant Backup error

    Open the registry of the SQL Server machine and navigate to HKLM\System\CurrentControlSet\Services\lanmanworkstation\parameters

    Create a new DWORD value named SessTimeout

    Set the value to decimal 600 (hex 0x258)

    This corrected...

Viewing 2 posts - 1 through 2 (of 2 total)