CREATE PROCEDURE [dbo].[up_read_new_mail]
	@character_id	[uniqueidentifier]

as 
set nocount on
 set transaction isolation level read uncommitted

select * from dbo.MailTable with (nolock) where character_id = @character_id and is_open = 0;

return @@error