I got it to work on Sql2005 with minor changes

Here's the code

if exists (select * from sys.objects where object_id = OBJECT_ID(N'[dbo].[TableInfo]') and type in (N'P', N'PC'))

drop procedure [dbo].[TableInfo]

go

set ansi_nulls...