>What I’m looking for is a way to immediately recompile and get result back to see if it was recompile with or without error.
I understand that, and I'm not sure there is a way to do it programatically. It may be possible to use DMO to cycle through the procs/UDF's, alter, save, and trap errors, but it isn't something I've done.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
