Page 1 of 1

Batch file that creates MSSQL database and users

Posted: 27 Sep 2012 10:37
by djangofan
I created a batch file that creates MSSQL database and users. Would love it if someone could fork my code (on Gist at GitHub) and improve my script. The idea behind this script is to create a database with a "user schema" so that multiple users can use the same database because tables can be referenced like DB.username.TABLE rather than DB.dbo.TABLE .

https://gist.github.com/3792028

http://thegreenoak.blogspot.com/2012/09 ... abase.html