All public logs

Combined display of all available logs of wiki karavi. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 10:43, 11 January 2025 Karavi talk contribs created page Sql Shrink (Created page with "Script to shrink all databases: declare @db varchar(255) declare c cursor for select name from sys.databases where is_read_only=0 and state=0 and name not in ('master','model','tempdb','msdb') open c fetch c into @db while @@fetch_status=0 begin exec SP_dboption @db,'trunc. log on chkpt.','true' DBCC shrinkdatabase (@db,10) fetch next from c into @db end close c deallocate c")