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

  • November 28, 2012 at 12:29 am

    #1562943

    I don't think you can.

    You can't use the "USE database" statement in a stored procedure and you cannot qualify the schema with a database name in the CREATE SCHEMA statement.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP