Comments by Dileep Mada

Dileep Mada 9-Feb-15 22:26pm View

Reason for my vote of 4 \n Good one

Dileep Mada 4-Nov-13 5:08am View

But in same session "select @@LOCK_TIMEOUT" is not returning the value we provided.

DECLARE @value BIGINT;
SET @value=2000
DECLARE @SQL NVARCHAR(1000)= N'SET LOCK_TIMEOUT ' + CAST(@value as Varchar(10)) + ' select @@Lock_TimeOUT';
print @SQL;
exec sp_executesql @SQL;

select @@LOCK_TIMEOUT

Output:
2000
-1

Dileep Mada 6-May-13 0:09am View

Thanks

Dileep Mada 6-May-13 0:08am View

Deleted

Thanks

Dileep Mada 2-May-13 7:21am View

Thanks :)

Dileep Mada 24-Feb-13 23:02pm View

Thank you so much.

Comments by Dileep Mada (Top 6 by date)