Code: |
exec sp_configure 'allow updates',1 reconfigure with override update sysobjects set ftcatid = 0 where ftcatid <> 0 declare @a int set @a = 1 while @a > 0 begin set rowcount 300000 delete from sysfulltextnotify select @a = @@rowcount end update syscolumns set colstat = colstat & ~16 update sysindexes set status = status & ~33554432 update sysobjects set status = status & ~200, ftcatid = 0 exec sp_configure 'allow updates',0 |
Code: |
EXEC sp_dbcmptlevel @dbname ='<Database Name>', @new_cmptlevel = '90' GO use [Report] GO Alter authorization on database:: '<Database Name> to sa Alter database [Report] set parameterization forced GO |
output generated using printer-friendly topic mod, All times are GMT + 2 Hours