Obsolete Aliases

Hi,

On a SQL 2000 SP2 box that pre-dates me, I have some databases that came
from who knows where, and in the sysusers table there are some orphaned
records (no master..syslogins records that match on sid) which are aliases
(isaliased = 1). I'd like to clean them up, but sp_dropalias won't work if
the corresponding login does not exist on the server. I imagine that I can
use "EXEC sp_configure 'allow updates', 1" and directly delete the sysusers
table. Is there a better way?

--
Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org


.

Relevant Pages

  • Re: SQL Database size excessively increasing after Site Collection Restore
    ... Get a SQL Server DBA who knows what he is doing! ... restores are performed all actions are performed by stsadm. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Relational-to-OOP Tax
    ... Many SQL vendors has text mining features. ... Tutorial D isn't availible in production databases. ... The Third Manifesto,2 object functionality and the relational model are ...
    (comp.object)
  • Re: [PHP] is there a problem with php script pulling HTML out of database as it writes the page??
    ... I even had one tell me "SQL injection? ... about databases, server management, mail, or anything. ... I have a ghostwriter who keeps me active on the mailing lists. ...
    (php.general)
  • DataArchitect Version 3.5 Now On HP-UX
    ... DataArchitect is a powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer, create and modify a database through ODBC and perform advanced SQL functions. ... Data Architect is an emerging enterprise tool for designing databases at all levels of an organization using the same concepts found in tools costing thousands of dollars! ... Minimize/Maximize feature on diagram objects ...
    (comp.sys.hp.mpe)