IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_UserInsert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_UserInsert]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_UserInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_UserInsert] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_UserInsert]
            @UserName			nvarchar(50)
           ,@DisplayName		nvarchar(50)
           ,@Password			nvarchar(2048)
           ,@Role				smallint
           ,@LastModified		datetime
           ,@LastModifiedBy		nvarchar(50)
           ,@LocalOnly			bit
		   ,@new_id				int				output
		   ,@errorNumber		int				output
		   ,@errorMessage		nvarchar(250)	output 
AS
BEGIN
	set @errorNumber = 0; 	set @errorMessage = space(0);
	insert into [dbo].[Users]
           ([UserName]
           ,[DisplayName]
           ,[Password]
           ,[Role]
           ,[LastModified]
           ,[LastModifiedBy]
           ,[LocalOnly])
     values
           (@UserName
           ,@DisplayName
           ,@Password
           ,@Role
           ,@LastModified
           ,@LastModifiedBy
           ,@LocalOnly)
		    
	SET @new_id = SCOPE_IDENTITY();

END





























GO