Skip to content

Instantly share code, notes, and snippets.

View tknaller's full-sized avatar

Thomas tknaller

View GitHub Profile
for that:
https://answers.microsoft.com/en-us/office/forum/office_2013_release-outlook/internet-calendar-subscriptions-error-0x80004005/31dc0c54-a0ca-4304-9227-18d2e1325b87?page=5
https://support.google.com/calendar/thread/7486991?hl=en
DTSTART:(.*?)\n(?!(DTEND|RRULE))
SELECT
'USE [' + d.name + N']' + CHAR(13) + CHAR(10)
+ 'DBCC SHRINKFILE (N''' + mf.name + N''' , 0, TRUNCATEONLY)'
+ CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10)
FROM
sys.master_files mf
JOIN sys.databases d
ON mf.database_id = d.database_id
WHERE d.database_id > 4;
USE MASTER
declare
@isql varchar(2000),
@dbname varchar(64)
declare c1 cursor for select name from master..sysdatabases where name not in ('master','model','msdb','tempdb')