1 files changed, 19 insertions, 0 deletions
diff --git a/www/wiki/maintenance/mssql/archives/patch-drop-rc_cur_time.sql b/www/wiki/maintenance/mssql/archives/patch-drop-rc_cur_time.sql
new file mode 100644
index 00000000..01c46d31
--- /dev/null
+++ b/www/wiki/maintenance/mssql/archives/patch-drop-rc_cur_time.sql
@@ -0,0 +1,19 @@
+DECLARE @sql nvarchar(max),
+	@id sysname;--
+
+SET @sql = 'ALTER TABLE /*_*/recentchanges DROP CONSTRAINT ';--
+
+SELECT @id = df.name
+FROM sys.default_constraints df
+JOIN sys.columns c
+	ON c.object_id = df.parent_object_id
+	AND c.column_id = df.parent_column_id
+WHERE
+	df.parent_object_id = OBJECT_ID('/*_*/recentchanges')
+	AND c.name = 'rc_cur_time';--
+
+SET @sql = @sql + @id;--
+
+EXEC sp_executesql @sql;--
+
+ALTER TABLE /*_*/recentchanges DROP COLUMN rc_cur_time;