Delete users in table sysusers of oscar

• brinster

  SSC Journeyman

  Points: 99

  More actions

  November 7, 2003 at 7:59 am

  #81454

  Hello

  We make a restoration of database in this database there is a sysusers tables with login and users ;which is the method to delete this login in sysuers tables

  The second problem is that we have drop a database ODBC link and recreate behing this odbc link and there the application has never run after this recreation of ODBC link why ?

  Wich is the link between ODBC sql and database mssql 7 i don t see ?

  Regards

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 7, 2003 at 8:02 am

  #481262

  Do not directly update the system tables

  http://support.microsoft.com:80/support/kb/articles/Q274/1/88.ASP&NoWebContent=1

  http://www.sqlservercentral.com/sitesearch/cgi-bin/es/esearch.asp?start=0&perPage=10&summary=yes&sort=rank&search=orphaned+user

  might help you with respect to your first problem.

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  Another one:

  http://vyaskn.tripod.com/troubleshooting_orphan_users.htm

  Edited by - Frank Kalis on 11/07/2003 08:05:01 AM

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]