I would like to create a stored procedure that can be called from the master database to create a new database.

I can successfully create a database with out using variables for the database name and the device names. As soon as I change them to variables I get errors all over the place. Can this be done in SQL 7.0 or is this something that can not be done?

If someone would have a sample I would appriciate it.



Thanks

Tom