Thursday, July 2, 2015

Drop User from all databases

--Change user name
exec sp_MSforeachdb 'select ''USE ["?"]'' + char (10) + char(13) + ''GO''  + char (10) + char(13)  + ''DROP USER '' + QUOTENAME(NAME) + char (10) + char(13) + ''GO'' + char (10) + char(13)  from ?..sysusers
where name like ''username'''

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home