InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 09:43:43 GMT20http://www.sqlservercentral.com/Forums/Topic1412176-146-1.aspxCertainly. Code repository systems work on this concept.Thu, 11 Apr 2013 16:38:20 GMTmmartin1http://www.sqlservercentral.com/Forums/Topic1412176-146-1.aspx[quote][b]mpradeep23 (1/27/2013)[/b][hr]Hi Can i store the database creation script in a table call the script in stored procedure to create new database with tables and stored procedure can any one give me idea about thisthankswith best regardspradeep[/quote]Yes, but you will have to use dynamic SQL to actually execute scripts stored in a table as character strings. Set a variable of datatype (n)varchar with adequate scale equal to the result of the SELECT statement that returns the query you want, then run the sp_executesql system stored procedure with that variable as the input parameter value.Tue, 29 Jan 2013 08:09:27 GMTwolfkilljhttp://www.sqlservercentral.com/Forums/Topic1412176-146-1.aspx[quote][b]mpradeep23 (1/27/2013)[/b][hr]Can i store the database creation script in a table call the script in stored procedure to create new database with tables and stored procedure [/quote] Yes this can be done but if you rather create .sql files and then call them with the help of sqlcmd then that will be much simpler and easy to troubleshootMon, 28 Jan 2013 04:03:51 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1412176-146-1.aspxHi Can i store the database creation script in a table call the script in stored procedure to create new database with tables and stored procedure can any one give me idea about thisthankswith best regardspradeepSun, 27 Jan 2013 22:14:33 GMTmpradeep23