The sp_resetstatus works Ok, thanks for your support!

Maybe you have a common trouble when you restore a database, try whit this:

use master

go

exec sp_configure 'allow updates','1'

go

reconfigure with override

go

Use <db with lost users>

update u

set u.sid = l.sid

from sysusers u

inner...

Thanks to all of you!

I'm so lazy... i really miss my 'backup table' option en 6.5 version...jajajaja

Thanks Brian and Antares686 !

bkelley, this is the exact message:

DBCC TRACEON 208, server process ID (SPID) 19.

I don't turn any flag

Thanks for all friends! I can resolve this...

Simon, what you mean? I'm logged as a SA...

quote:

---

Not possible unless you have profiling setup

Simon Sabin

Co-author of SQL Server 2000 XML Distilled