Home Forums SQL Server 2008 T-SQL (SS2K8) Create database and schema dynamically RE: Create database and schema dynamically

  • November 28, 2012 at 1:39 am

    #1562972

    this one works:

    set @sql = 'exec '+ QUOTENAME(@dbname) + '..sp_executesql N''create schema MyNewSchema'''

    exec (@sql)