I work in goverment, and DBA is the cheap employee but of the organization, above of that employee this the secretary of the manager/boss.

Yes, that is crazy, because that employee...

use a Julian calendar instead of a traditional one

Julian!!!!

I don't now,

 but

you try the triggers?

CREATE FUNCTION noleftzero(@word varchar(20))

RETURNS varchar(20)

AS

BEGIN

 WHILE PATINDEX('0%', @word) = 1

 BEGIN    

    set @word = right(@word,len(@word)-1)

 END

   RETURN(@word)

END

go

/*************/

SELECT dbo.noleftzero('L0001AA') as nozero

What you think about a function?

CREATE FUNCTION noleftzero(@word varchar(20))

RETURNS varchar(20)

AS

BEGIN

 WHILE PATINDEX('0%', @word) = 1

 BEGIN    

    set @word = right(@word,len(@word)-1)

 END

   RETURN(@word)

END

go

/*************/

SELECT dbo.noleftzero('L0001AA') as nozero

I'm not a expert but a think this...

try :

selec * from tableA with HOLDLOCK

/*any procesess and others users try to access this tableA but they can't.*/

Update tableA set field='tutu' where id=1

commit tran

/*now others users try to access...