spCheckDuplicateCharName Script

[ThroneX]

The database is missing that stored procedure so I need it to fix my problem.
Can some one give me the script of it?

[MentaL]

[Phoenix]

GO
/****** Object:  StoredProcedure [dbo].[spCheckDuplicateCharName]    Script Date: 02/01/2011 20:15:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[spCheckDuplicateCharName]   
 @Name varchar(24)  
as
 set nocount on  
 select top 1 cid from character(nolock) where deleteflag <> 1 and name = @Name

[Dave]

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spCheckDuplicateCharName]    Script Date: 06/04/2011 17:56:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create proc [dbo].[spCheckDuplicateCharName]   
 @Name varchar(24)  
as
 set nocount on  
 select top 1 cid from character(nolock) where deleteflag <> 1 and name = @Name

This?

AFF PHOENIX FASTER :@

[ThroneX]

Thanks both.