DEFINITIONS

Definitions More Info.
Definition ID166
TitleSQL
CategoryMS_SCRIPT
DefinitionSecureOrphanedUserAutoFix- DB ile Server kullanicilari esleme
Definition DescriptionSET QUOTED_IDENTIFIER OFF
GO

DECLARE @SQL varchar(100)

DECLARE curSQL CURSOR FOR
select "exec sp_change_users_login 'AUTO_FIX','" + name + "'"
from sysusers
where issqluser = 1 and name = 'tehauser'

OPEN curSQL

FETCH curSQL into @SQL

WHILE @@FETCH_STATUS = 0
BEGIN
EXEC (@SQL)
FETCH curSQL into @SQL
END

CLOSE curSQL
DEALLOCATE curSQL

go
RecordBycunay
Record Date21-02-2012 14:10:35
Düzenle
Kopyala
Sil