Viewing 2 posts - 1 through 2 (of 2 total)
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
March 6, 2008 at 7:37 am
#785972
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...
February 5, 2008 at 11:05 am
#775250