InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 16:07:16 GMT20http://www.sqlservercentral.com/Forums/Topic424921-147-1.aspxhttp://www.sqlservercentral.com/scripts/DDL/72638/Mon, 14 Mar 2011 01:46:37 GMTSQL_ME_RICHhttp://www.sqlservercentral.com/Forums/Topic424921-147-1.aspxusing Visual Source Safe. check the following linkhttp://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1093178,00.htmlThu, 22 Nov 2007 07:02:22 GMTvyashttp://www.sqlservercentral.com/Forums/Topic424921-147-1.aspx[quote][b]zafar (11/22/2007)[/b][hr]i wants maintain different versions of my database ie (SP, tables etc)How can i do that ?[/quote]You could script your database and keep the script files in source control. This can be automated with SMO, but it may become tedious when it comes to seeing the differences between your different versions.You could also look at third party tools like:Microsoft Visual Studio Team System for Database Professionals,Red Gate's SQL Compare ProfessionalDBGhostThese allow you to use source control with your database objects.Disclaimer: I work for Red Gate.Regards, AndrasThu, 22 Nov 2007 06:09:54 GMTAndras Belokosztolszkihttp://www.sqlservercentral.com/Forums/Topic424921-147-1.aspxi wants maintain different versions of my database ie (SP, tables etc)How can i do that ?Thu, 22 Nov 2007 04:11:56 GMTzafar-458126