You should be able to Delete data from all tables in a SQL server database by running the following TSQL command.
EXEC sp_MSforeachtable @command1 = ‘DELETE FROM ?’
Note: You might see some errors if there are foreign key constraints in your database. Just keep executing the above command until you see no errors and you should [...]

Here is a way to delete all stored procedures from an SQL Server 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
[...]