• Ah, those powerusers with their whole bunch of specialities...

    Well then, I don't know if you can reference a db with osql that doesn't already exist.

    I would use dynamic sql and I guess you the pitfalls, right?

    A very basic script for creating the db could look like

    
    
    declare @stmt nvarchar(1000)
    declare @dbname nvarchar(10)
    set @dbname = 'FRANK_1'
    set @stmt = 'CREATE DATABASE ' + @dbname
    EXEC sp_executesql @stmt

    results in

    
    
    Der CREATE DATABASE-Prozess reserviert 0.75 MB auf dem Datenträger 'FRANK_1'.
    Der CREATE DATABASE-Prozess reserviert 0.49 MB auf dem Datenträger 'FRANK_1_log'.

    Frank

    http://www.insidesql.de

    http://www.familienzirkus.de

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]