Delete users in table sysusers of oscar | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Delete users in table sysusers of oscar

Hello
We make a restoration of database oscar and in the sysuser table of the oscar database the is login of old user How we do to delete this user in the sysusers tables of database Regards
Do not update/delete system tables directly and to fix the orphaned users take help from this KBAhttp://support.microsoft.com/defaul…port/kb/articles/Q274/1/88.ASP&NoWebContent=1
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com
I’ll second satya, playing around with SQL Server’s system tables, is a quick and easy way to fool SQL Server. You might try to search the web, there are a lot of scripts out there and that’s the reason why I can’t find a single one right now. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
]]>