InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 01:49:00 GMT20http://www.sqlservercentral.com/Forums/Topic1411520-145-1.aspxIn its simplest form:[code="sql"]CREATE PROC dbo.createnewdb (@dbname SYSNAME)AS BEGIN DECLARE @sql NVARCHAR(MAX) = N'CREATE DATABASE ' + QUOTENAME(@dbname); EXEC(@sql);ENDGO[/code][code="sql"]EXEC dbo.createnewdb N'newdb';[/code]There are too many considerations to list here before creating a stored procedure like this and allowing folks to call it but something like I showed should get you started.Fri, 25 Jan 2013 07:37:39 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1411520-145-1.aspxWe need to something to do with having a stored procedure that someone could execute that could create a new database on the instance?Fri, 25 Jan 2013 07:26:39 GMTsram24_mcahttp://www.sqlservercentral.com/Forums/Topic1411520-145-1.aspxAre you asking whether you should design your database to only allow accessing data via stored procedures? Or something to do with having a stored procedure that someone could execute that could create a new database on the instance? Can you please clarify?Fri, 25 Jan 2013 07:08:08 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1411520-145-1.aspxHi, Is there any way to create the database using stored procedure ? We want to create the database using stored procedure which is the best way to handle it?Regards,Ram.Fri, 25 Jan 2013 01:42:40 GMTsram24_mca