select distinct a.Grantee from UserAuthentication a where not exists(select s.LoginName from ServerLogins s where a.Grantee=s.LoginName ) --------------------------------------------------------------------------------------- select count(w.CallId) from WebServiceCallLog w where not exists (select * from dbo.WebServiceCallLogArchive a where w.CallId=a.CallID) ------------------------------------------------------------------------------------------ SELECT K.name as Guncel_DB, K.crdate, S.ip, S.name as Server_Ad FROM DOLBackup_Databases1 K,DOLBackup_Servers S WHERE NOT EXISTS (SELECT O.name FROM DOLBackup_Databases O WHERE O.name=K.name) AND K.sourceserverid=S.id ORDER BY K.sourceserverid Select DOLBackup_Servers."name", DOLBackup_Servers."ip", DOLBackup_Databases1."Name", DOLBackup_Databases1."crdate" From dbo.DOLBackup_Databases1 DOLBackup_Databases1, dbo.DOLBackup_Servers DOLBackup_Servers Where Not Exists(Select DOLBackup_Databases.name From dbo.DOLBackup_Databases DOLBackup_Databases Where DOLBackup_Databases.name = DOLBackup_Databases1.Name) And DOLBackup_Servers.id = DOLBackup_Databases1.sourceserverid
