Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Delete entry in SYSUSERS table under SQL server 7
- Thread starter EM1107
- Start date
Sure. The easiest way to to use the stored procedure, sp_DropUser. If you cannot do this, for various reasons I can think of, then you will have to set the Server option 'Allow modifications to be made directly to the system catalogs' to True, then you can delete from the sysusers table.
Chris
Chris
- Status
Similar threads
- Locked
- Question
- Locked
- Question
