DEFINITIONS

Definitions More Info.
Definition ID129
TitleSQL
CategorySCRIPT
DefinitionUSER_FIX
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 = 'YorumAdmin'
---- user name buraya yazılacak
OPEN curSQL FETCH curSQL into @SQL
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC (@SQL)
FETCH curSQL into @SQL
END CLOSE curSQL
DEALLOCATE curSQL
RecordBycunay
Record Date21-02-2012 11:37:38
Düzenle
Kopyala
Sil