Re: Cannot Drop Users

How about droping those users using their UIDs?

--
Ekrem Önsoy



"Zekske" <Zekske@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5F1C729C-D7CC-4E48-BFB7-B3124DB0A7BB@xxxxxxxxxxxxxxxx
Strange problem.
I attached databases from a SQL7.0 server in domain A on a SQL 2000 server
in domain B.
When I try to drop de database users with the sp_dropuser command I get the
message user does not exists.
Strange thing is that when I execute sp_helpuser I can see the users but
when I execute SP_Change_users_login 'report', there not listed.
Those users are domainusers.

Anyone an idea what's causing this. the only way to delete them is via the
EM or via the sysusers.

Regards

.

Relevant Pages

  • 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... the server. ... MSDE either from the Setup or from the SQL2KDeskSP3 execute. ... it does look like some of the sample databases have been ... >> and they directed me to install MSDE and they attached a ConfigSamples ...
    (microsoft.public.sqlserver.msde)
  • Re: 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... The fact that the other databases exists phyiscally doesn´t mean that they ... can try to connect to SQL Server using OSL or a GUI. ... The Command OSQL ist for the commandline under DOS. ... > this MSDE either from the Setup or from the SQL2KDeskSP3 execute. ...
    (microsoft.public.sqlserver.msde)
  • Re: Run same query against multiple tables
    ... There is the undocumented stored procedure: ... It will execute the command specified for the databases on your server. ...
    (microsoft.public.sqlserver.mseq)
  • Re: SQL Enable FullText automaticly on reboot
    ... Create a stored procedure and mark it as a startup stored procedure ... > Is there a way to execute the sp_fulltext_enable stored proc automaticly ... > after a server rebooted on all the databases in the server? ...
    (microsoft.public.sqlserver.programming)
  • Re: File Upload - Security Issues
    ... uploaded and the user could upload any or all of these in theory. ... There is no one product that can give you 100% security, ... > Code doesn't execute in local memory space unless remote user has rights ... > You don't have MS Office installed on the server. ...
    (microsoft.public.scripting.vbscript)