• Hi Lowell,

    i wrote very similliar procedure as yours in my work to check procedures. My procedure throws RAISERROR when alter can't be done. It helps when it's missing column in table used in procedure which you are checking, but if in database NOT EXISTS table used in checked procedure, alter is working without error (i checked that ALTER works properly but execution of procedure throws error: 'Invalid object name table_name'. Anybody knows how to check procedure in this case?