re: error 21008 when adding new user

From: Charlie (charlesg_at_bes.ci.portland.or.us)
Date: 08/25/03 

Date: Mon, 25 Aug 2003 10:58:28 -0700

I believe this means the user id in master db is out of
sync with the user id in your database. Run this system
stored procedure against your database and it should
resolve the problem.

sp_change_users_login 'Auto_fix', username

Replace 'username' with the problem user.

- Charlie

>-----Original Message-----
>i am getting this message ([sql-dmo]user already exists
in
>database)when trying to add a user but they are not in
the
>list??? any help appreciated
>.
>

Relevant Pages

  • Re: Extended Stored Procedure: Get the current db of the client
    ... with the caveat that you don't recommend it because Microsoft ... of a stored procedure versus umpteen of the same stored procedure spread ... I am not going after Gert Sue. ... the database context as a parameter if you need it, ...
    (microsoft.public.sqlserver.odbc)
  • Trying to set up a SQL Server Agent Account and I hit a wall....
    ... Our database is on SQL Server 2005, however it is set to compatibility mode ... You may need to set the compatibility level ... of the current database to a higher value to enable this feature. ... for the stored procedure sp_dbcmptlevel. ...
    (microsoft.public.sqlserver.security)
  • Re: custom insert for databound datagridview
    ... There probably is a way to insert your own change tracking logic, but I think using Sync Services, which already provides change tracking logic inside the SQL Compact engine might be easier in the long run. ... Here's a sample for syncing with an Oracle database using a custom ... I am syncing between a PDA SQLCE ...
    (microsoft.public.sqlserver.ce)
  • Re: Extended Stored Procedure: Get the current db of the client
    ... I am not going after Gert Sue. ... the database context as a parameter if you need it, ... Did you ever write an extended stored procedure? ... different than an extended stored procedure, so that is not giving you want ...
    (microsoft.public.sqlserver.odbc)
  • Re: custom insert for databound datagridview
    ... gets put into the database until you hit the save button on the navigation ... CTP you can download that handles syncing with a mobile device, ... the desktop piece is SQL Server so you'd still need to write a custom sync ... I am syncing between a PDA SQLCE ...
    (microsoft.public.sqlserver.ce)