Please help, I'm desperate!

[alecken]

I've been trying for exactly a month now to create databases from ColdFusion
with no success and I've used up all resources I could possibly found. Now I'm
changing my gear by creating the databases from the SQL side using a simple sql
script. I'm using microsoft SQL and I know this is a forum for CF, not SQL but
what I'm about to do is the back end of my cf application. I appreciate all the
help I can get at this point. I just need to loop over a create database
statement in SQL analyzer. My script generate error, I'm not sure my sntax is
correct and I need Help!!!!!! Thank you!!!!!!!!!!!!!!!!! declare @loopnumber
int select @loopnumber = 101 declare @dbname varchar While @loopnumber < 102
BEGIN select @dbname = 'DP_' + CAST(@loopnumber as varchar) /* SQL Script
start here */ CREATE DATABASE @dbname GO /* SQL Script end here */ select
@loopnumber = @loopnumber + 1 END

[nmconsulting]

declare @loopnumber int ,@string_to_execute varchar(255) select @loopnumber =
101 While @loopnumber < 102 BEGIN select @string_to_execute = 'CREATE
DATABASE DP_' + CAST(@loopnumber as varchar) exec (@string_to_execute) select
@loopnumber = @loopnumber + 1 END

[alecken]

Thank you so much!!!!