RE: Orphaned logins in SQL 2000?
I move databases aaround quite a bit, so I created a little script to do this for all of the logins in the database. Mike DECLARE @sLogin VARCHAR(50) DECLARE cursor_LoginList CURSOR FOR SELECT NAME FROM sysusers WHERE status = 2 AND NAME <> 'dbo' AND NAME IN (Select name from master.dbo.syslogins) OPEN cursor_LoginList FETCH NEXT […]
2003-05-08