USE master SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON EXEC sp_configure 'allow updates', 1 EXEC sp_MS_upd_sysobj_category 1 RECONFIGURE WITH OVERRIDE GO IF OBJECT_ID(N'dbo.sp_who_3') IS NOT NULL DROP PROC dbo.sp_who_3 GO IF OBJECT_ID(N'dbo.sv_block') IS NOT NULL DROP VIEW dbo.sv_block GO IF OBJECT_ID(N'dbo.sv_sysprocesses') IS NOT NULL DROP VIEW dbo.sv_sysprocesses GO IF EXISTS (SELECT * FROM dbo.sysobjects WHERE uid = USER_ID(N'system_function_schema') AND name = N'fn_view_input_buffer') DROP FUNCTION system_function_schema.fn_view_input_buffer GO EXEC sp_configure 'allow updates', 0 EXEC sp_MS_upd_sysobj_category 2 RECONFIGURE WITH OVERRIDE GO