Cleanup logins

wygenerowanie skryptów do Usuniecie uzytkownikow

select sp.name as login,
'DROP LOGIN  '+ sp.name +'; '
from sys.server_principals sp
left join sys.sql_logins sl
          on sp.principal_id = sl.principal_id
where 
 sp.type_desc ='SQL_LOGIN'
and sp.type not in ('G', 'R')
and  sp.name like 'user_db%'
order by sp.name;

wygenerowanie skryptów do Usuniecie bazy

SELECT name, database_id, create_date  ,
    'select sum([executionTimeMs]) from ['+ name+'].[dbo].[scriptRunner]',
    'drop database  ['+ name+']; delete from [platforma-api].[app].[hosting] where hosting_db = ''' + name +''''
FROM sys.databases where name like 'db_%';