Original Sproc
        
        CREATE PROC testProc
	as
		SELECT stuff FROM myTable
		WHERE  which_stuff = "my stuff"
        go

        Modified Sproc

        CREATE PROC testProc
	as
		SELECT stuff FROM myTable
		WHERE  which_stuff = "my stuff"
		AND    is_deleted = 'N'
        go