1 files changed, 19 insertions, 0 deletions
diff --git a/www/wiki/maintenance/mssql/archives/patch-drop-user_options.sql b/www/wiki/maintenance/mssql/archives/patch-drop-user_options.sql
new file mode 100644
index 00000000..ab379567
--- /dev/null
+++ b/www/wiki/maintenance/mssql/archives/patch-drop-user_options.sql
@@ -0,0 +1,19 @@
+DECLARE @sql nvarchar(max),
+	@id sysname;--
+
+SET @sql = 'ALTER TABLE /*_*/mwuser 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('/*_*/mwuser')
+	AND c.name = 'user_options';--
+
+SET @sql = @sql + @id;--
+
+EXEC sp_executesql @sql;--
+
+ALTER TABLE /*_*/mwuser DROP COLUMN user_options;