>I'm creating a dbf that contains the name of tables and stored procedures that are no longer used (or ever used) in the current database design. Is there a way, using SQL_DMO that I can process that list. I have 8 client sights that I want to "clean up". So I thought I'd make a dbf of things to be removed and then create a small vfp exe to run at each site. I've never really programmed using the sqldmo object, thanks for any insight or links
>
>Kirk
You'll have to drill down to the SP object and call it's Remove method. DMO is covered pretty well in the SQL Books Online.
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.