← All posts tagged change

pc
W7 time date change дать права юзеру менять дату и время в Windows 7
Computer configuration -> Windows Settings -> Security Settings -> Local policies -> User rights assignment
Параметр Change the system time

обязательно перезагрузить комп
pc
sa msSQL change owner dbo if not exists (select top 1 1 from sys.database_principals su
where su.name = 'dbo' and suser_sname(su.sid) = 'sa')
and exists (select top 1 1 from sys.server_principals sp where name
= 'sa')
and (IS_SRVROLEMEMBER ('sysadmin', 'sa') = 1)
begin
exec sp_changedbowner 'sa'
end