Delete All Stored Procedures and Tables from a single Query

hi to all of u
some time we in need to delete all stored procedures and tables from database
so for that we need a single query which do the all the work. below is the query once u run both query all tables and stored procedure of that database is drooped.
but carefully because once you dropped u cant get them back--
----------drop all tables from database-----------

exec sp_MSforeachtable "DROP TABLE ? PRINT '? to be dropped' "






------------drop all sp's in a database---------------


DECLARE @procedureName varchar(500)
DECLARE cur CURSOR
FOR SELECT [name] FROM sys.objects WHERE type = 'p'
OPEN cur

FETCH NEXT FROM cur INTO @procedureName
WHILE @@fetch_status = 0
BEGIN
EXEC('DROP PROCEDURE ' + @procedureName)
FETCH NEXT FROM cur INTO @procedureName
END
CLOSE cur
DEALLOCATE cur


this works i have tested it several time with MS sql server 2005

ERP

as most of the friends know that i m working as a software developer ,and currently i m working on two different projects both are erp's but have a very much difference .
but one thing is clear in my mind that any erp for any industry its fits on the below definition .





Enterprise resource planning (ERP) is an integrated computer-based system used to manage internal and external resources including tangible assets, financial resources, materials, and human resources. It is a software architecture whose purpose is to facilitate the flow of information between all business functions inside the boundaries of the organization and manage the connections to outside stakeholders. Built on a centralized database and normally utilizing a common computing platform, ERP systems consolidate all business operations into a uniform and enterprise wide system environment.

An ERP system can either reside on a centralized server or be distributed across modular hardware and software units that provide "services" and communicate on a local area network. The distributed design allows a business to assemble modules from different vendors without the need for the placement of multiple copies of complex, expensive computer systems in areas which will not use their full capacity


above definition taken from Wikipedia .

what a industry gets from an erp

i think the erp does not increase your profit but it saves your business from small size losses ,which are not countable individually but make huge difference in collective manner.

My first blog

i am looking for a long time to start blogging but due to lake of time i started now.
i asked gajanan abt bolgging one of my new friend who is the active blogger .he said write anything "ulta-pulta ".
so finally all of u prepare for the read some "ulta-pulta",