dbcc traceon (1204, 3605, -1)

go

dbcc tracestatus(-1)

go

The -T1204 startup parameter collects information about the process and the resources when the deadlock detection algorithm encounters a deadlock. The -T3605 startup parameter writes...

SELECT TOP 1 * FROM #Parameters

WHERE

ParameterTimestamp <= '2012-07-16 15:00:00' -- timestamp

AND ParameterID='A1' -- parameterId

ORDER BY ParameterTimestamp DESC

Error block is missing for the statement GOTO Error.