OK, here is!
alter procedure sp_new_database
(
@campaign_name varchar(50),
@campaign_client int,
@database_name nvarchar(30),
@database_path nvarchar(100),
@database_size int = 100, -- MB
@database_growth smallint = 10 -- %
)
as
begin
set nocount on
set statistics io off
declare @sql nvarchar(4000), @error smallint
-- database existence...