SQLServerの排他処理

using System;
using System.Data.SqlClient;

public class test
{
    public static void Main(string[] args)
    {
        Console.WriteLine("Lock Start: {0}", DateTime.Now.ToString(@"yyyy/MM/dd HH:mm:ss.fffff"));
        try
        {
            using(SqlConnection con = new SqlConnection("server=localhost;database=WORK;uid=sa;password="))
            {
                con.Open();
                SqlTransaction tran = con.BeginTransaction();
                try
                {
                    string sql = "SET LOCK_TIMEOUT 0 \n";
                    sql += @"SELECT * FROM KBN_TBL WITH (ROWLOCK, UPDLOCK) WHERE KBN_KEY = 1";
                    SqlCommand cmd = new SqlCommand(sql, con, tran);
                    for(int cnt = 0; cnt < 10; cnt++)
                    {
                        try
                        {
                            cmd.ExecuteScalar();
                            Console.WriteLine("Not Locked");
                            System.Threading.Thread.Sleep(3000);
                            break;
                        }
                        catch(SqlException ex)
                        {
                            System.Threading.Thread.Sleep(500);
                            Console.WriteLine("[{0}] {1}", ex.Number, ex.Message);
                        }
                    }
                    tran.Commit();
                }
                catch
                {
                    tran.Rollback();
                    throw;
                }
            }
            Console.WriteLine("Lock End: {0}", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fffff"));
        }
        catch(Exception ex)
        {
            Console.WriteLine(ex.ToString());
        }
    }
}