Skip to content

Instantly share code, notes, and snippets.

@jotdhaliwal

jotdhaliwal/1.txt

Created January 29, 2020 12:32
Show Gist options
  • Save jotdhaliwal/7e5b9896e1cf37a1602ed0def7c3c956 to your computer and use it in GitHub Desktop.
Save jotdhaliwal/7e5b9896e1cf37a1602ed0def7c3c956 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
1.txt
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
update SearchIndex set IsIndexed = 0
GO
COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment