Return to Answer

for the users that do not have a login in the server follow this link:

--technet article on orphaned users

Report on failed users - shows all SQL users on server

USE [<database>]
EXEC sp_change_users_login  'REPORT'

--SQL 2000 and earlier
USE [<database>]
EXEC sp_change_users_login  'Auto_Fix', 'MyUser'

--SQL 2005 onwards
USE [<database>]
ALTER USER [MyUser] WITH LOGIN = [MyUser]

--to find database users (windows accounts) without Server login
select users.name, logins.name
from master..syslogins logins 
    right join sysusers users on logins.sid = users.sid 
where logins.sid is null 
   and issqlrole <> 1 
   and isapprole <> 1   
   and (users.name <> 'INFORMATION_SCHEMA' 
    and users.name not in ('guest', 'dbo', 'sys', 'system_function_schema'))
     

a number of process running for a long time that are blocking and causing other issues

for this I recommend the procedure called sp_whoisactive

for the users that do not have a login in the server follow this link:

--technet article on orphaned users

Report on failed users - shows all SQL users on server

USE [<database>]
EXEC sp_change_users_login  'REPORT'

--SQL 2000 and earlier
USE [<database>]
EXEC sp_change_users_login  'Auto_Fix', 'MyUser'

--SQL 2005 onwards
USE [<database>]
ALTER USER [MyUser] WITH LOGIN = [MyUser]

--to find database users (windows accounts) without Server login
select users.name, logins.name
from master..syslogins logins 
    right join sysusers users on logins.sid = users.sid 
where logins.sid is null 
   and issqlrole <> 1 
   and isapprole <> 1   
   and (users.name <> 'INFORMATION_SCHEMA' 
    and users.name not in ('guest', 'dbo', 'sys', 'system_function_schema'))
     

a number of process running for a long time that are blocking and causing other issues

for this I recommend the procedure called sp_whoisactive

for the users that do not have a login in the server follow this link:

--technet article on orphaned users

Report on failed users - shows all SQL users on server

USE [<database>]
EXEC sp_change_users_login  'REPORT'

--SQL 2000 and earlier
USE [<database>]
EXEC sp_change_users_login  'Auto_Fix', 'MyUser'

--SQL 2005 onwards
USE [<database>]
ALTER USER [MyUser] WITH LOGIN = [MyUser]

--to find database users (windows accounts) without Server login
select users.name, logins.name
from master..syslogins logins 
    right join sysusers users on logins.sid = users.sid 
where logins.sid is null 
   and issqlrole <> 1 
   and isapprole <> 1   
   and (users.name <> 'INFORMATION_SCHEMA' 
    and users.name not in ('guest', 'dbo', 'sys', 'system_function_schema'))
     

a number of process running for a long time that are blocking and causing other issues

for this I recommend the procedure called sp_whoisactive

I have already checked for orphaned users since it is the obvious thing. I also use sp_whoisactive, sp_blitzfirst and beta_lockinfo as tools other than scripts in my toolkit.

for the users that do not have a login in the server follow this link:

--technet article on orphaned users

Report on failed users - shows all SQL users on server

USE [<database>]
EXEC sp_change_users_login  'REPORT'

--SQL 2000 and earlier
USE [<database>]
EXEC sp_change_users_login  'Auto_Fix', 'MyUser'

--SQL 2005 onwards
USE [<database>]
ALTER USER [MyUser] WITH LOGIN = [MyUser]

--to find database users (windows accounts) without Server login
select users.name, logins.name
from master..syslogins logins 
    right join sysusers users on logins.sid = users.sid 
where logins.sid is null 
   and issqlrole <> 1 
   and isapprole <> 1   
   and (users.name <> 'INFORMATION_SCHEMA' 
    and users.name not in ('guest', 'dbo', 'sys', 'system_function_schema'))
     

a number of process running for a long time that are blocking and causing other issues

for this I recommend the procedure called sp_whoisactive

for the users that do not have a login in the server follow this link:

--technet article on orphaned users

Report on failed users - shows all SQL users on server

USE [<database>]
EXEC sp_change_users_login  'REPORT'

--SQL 2000 and earlier
USE [<database>]
EXEC sp_change_users_login  'Auto_Fix', 'MyUser'

--SQL 2005 onwards
USE [<database>]
ALTER USER [MyUser] WITH LOGIN = [MyUser]

--to find database users (windows accounts) without Server login
select users.name, logins.name
from master..syslogins logins 
    right join sysusers users on logins.sid = users.sid 
where logins.sid is null 
   and issqlrole <> 1 
   and isapprole <> 1   
   and (users.name <> 'INFORMATION_SCHEMA' 
    and users.name not in ('guest', 'dbo', 'sys', 'system_function_schema'))
     

a number of process running for a long time that are blocking and causing other issues

for this I recommend the procedure called sp_whoisactive

I had already checked for orphaned users since it is the obvious thing. I always use sp_whoisactive, sp_blitzfirst and beta_lockinfo as tools other than scripts in my toolkit.

for the users that do not have a login in the server follow this link:

--technet article on orphaned users

Report on failed users - shows all SQL users on server

USE [<database>]
EXEC sp_change_users_login  'REPORT'

--SQL 2000 and earlier
USE [<database>]
EXEC sp_change_users_login  'Auto_Fix', 'MyUser'

--SQL 2005 onwards
USE [<database>]
ALTER USER [MyUser] WITH LOGIN = [MyUser]

--to find database users (windows accounts) without Server login
select users.name, logins.name
from master..syslogins logins 
    right join sysusers users on logins.sid = users.sid 
where logins.sid is null 
   and issqlrole <> 1 
   and isapprole <> 1   
   and (users.name <> 'INFORMATION_SCHEMA' 
    and users.name not in ('guest', 'dbo', 'sys', 'system_function_schema'))
     

a number of process running for a long time that are blocking and causing other issues

for this I recommend the procedure called sp_whoisactive

I have already checked for orphaned users since it is the obvious thing. I also use sp_whoisactive, sp_blitzfirst and beta_lockinfo as tools other than scripts in my toolkit.