If I use the 'Use Dynamic SQL' option I can generate code. However, if I use create new or use existing stored procs it bombs since the owner is not in brackets [owner] .. for the generated sql or when it reads the schema. I am going to try use existing sprocs that has owner as dbo but prefixes everything in the sql with the [99xxx] owner. That may work but it is also just digging a deeper hole. Thanks for the input. I believe I am just going to do the work needed now to repair the db in the end.