Thanks TOM

Thank you all for your replys.

I will use this one:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER Procedure [dbo].[DropOrphanUserAccounts]

as

BEGIN

set nocount on

create table #UserAccountsToDelete

(

...

Bhuvnesh your solution is not what i asked for.

Your solution is not to delete User accounts that are orphan because the login was deleted...

But thanks.

I will try the other solution

In my case i think that i do not need that, but thanks

Lowel solution will solve my problem. Thank you

No need steve, i want to delete almost all the logins. But thanks

I have tried to execute the procedure from Lowel and other procedure where i put all the databases in single user mode. Non of this procedures work in one case...

I...

The procedure that Lowel gave me is very usefull but i think that you are right , it's better to put all the databases in to single user mode and...

ups.... lol thank you 🙂

thank you very much i will try that.

What about the other services like SQL Server Browser and others?

can someone help , please?

Thank you

I'm receiving this error when executed the stored procedure that i posted:

Msg 217, Level 16, State 1, Procedure RemoveLigacoes, Line 48

Maximum stored procedure, function, trigger, or view nesting level exceeded...

Didn't undestood your answer...

create procedure RemoveLigacoes

AS

BEGIN

DECLARE @DatabaseName nvarchar(100)

DECLARE @SPId int

DECLARE my_DBs CURSOR FAST_FORWARD FOR

select [name] from master.sys.databases

WHERE [NAME] NOT IN ('MASTER','MODEL','TEMPDB','MSDB','ADVENTUREWORKS')

OPEN my_DBs

FETCH NEXT FROM my_DBs INTO @databasename

WHILE @@FETCH_STATUS = 0

Begin

...

Thank you very much