USE SRO_VT_LOG
GO
CREATE PROCEDURE _CharLogOff
@CharID INT
AS
BEGIN
DELETE U FROM SilkroadPF.._User U JOIN SRO_VT_SHARD.._Char C ON C.CharName16=U.CharName WHERE C.CharID=@CharID
ND