Using Silverlight in Enterprise: RAD of User Friendly Database Access

if exists (select	*
             from dbo.sysobjects
            where	id = object_id(N'[dbo].[p_DbUpdateLog_Insert]')
              and	objectproperty(id, N'IsProcedure') = 1)
drop procedure [dbo].[p_DbUpdateLog_Insert]
go

/*
  Inserts record into Database Update Log table.
  If record with such name already exists, raises error.
*/

create procedure dbo.p_DbUpdateLog_Insert
(
  @Name UDT_LONGSTRING
)
as
begin
  if exists (select 1
               from DbUpdateLog l
              where l.Name = @Name)
  begin
    raiserror('Database update ''%s'' is already applied.', 16, 1, @Name)
    return
  end
  
  insert into DbUpdateLog
  (
    Name,
    InstallDateTime
  )
  values
  (
    @Name,
    getdate()
  )
end
go