I ran following on sql server 2008 r2 with no errors . you prbly need to check your sproc definition.

if exists(select * from sys.objects (nolock) where name =...

Thank you for clarifying Paul. Read your article on sqlmag.

Could be due to locking . You can monitor this with profiler .

Microsoft conect entry

http://connect.microsoft.com/SQLServer/feedback/details/620614/internal-query-processor-error-the-query-processor-could-not-produce-a-query-plan-sql-server-2008-r2

My friend gave me an interesting problem yesterday. He works for a hospital AND needs TO COUNT patient visits, IF a patient visits the doctor ON consecutive DAYS, it needs...

Thats clever.

SELECT Column_Name 'Column Name',table_name 'Table_Name;

Data_type 'Data Type', character_maximum_length 'Maxium Length'

FROM information_schema.columns

GROUP BY table_name

@julien : i ran the script on sql server 2008, worked fine for me.

thanks rudy