Query For Inactive account

[KimFox_12]

help can anyone give me this QUERY on SQL 05 delete the inactive account. if you said its on stickies but no... its still don`t work if you have working trigger please post... Thanks You All

 

[arvinyu1]

inactive?

im not sure if this is the code but you can try

USE RanUser

Delete [UserInfo]
From UserInfo
Where UserAvailable = 0

Delete the deleted characters

USE RanGame1

Delete [ChaInfo]
From ChaInfo
Where ChaDeleted= 1

 

[clever]

please explain more if you have already try and it works your db correctly