I am really surprised with the change I discovered last week in SQL Server 2008. Let’s analyze the code below: USE master GO IF OBJECT_ID(N 'sp_FindObject' ) IS NOT NULL DROP PROC dbo.sp_FindObject GO CREATE PROC dbo.sp_FindObject @ object sysname AS