View Single Post
 
Old 08-11-2015, 03:25 PM
pschulz pschulz is offline
Newcomer
 
Join Date: Jul 2015
Posts: 6
Default

its enough to seperate them?
If I have to create two databases within one methode, i get an error, whenver the stored procedure for the second db shall be createtd
Except I let create the databases with a simple statement like:
strSQL = "CREATE DATABASE " + strDBname
instead of
strSQL = "exec ('CREATE DATABASE ' + @databaseName)"

Have expect it runs better with exec, but it does not.

greetings
Reply With Quote