InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 01:58:38 GMT20http://www.sqlservercentral.com/Forums/Topic1365050-391-1.aspxPermissions roles etc will all depend on how you want to lock down access to the databases, only you know what the applications are doing to the database so only you can really decide what rights to give to users.The main thing I would say if setup a backup routine for the newly created database(s) as that will be critical.Thu, 27 Sep 2012 02:06:27 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1365050-391-1.aspxHi,is there a guide or checklist for deploy SQL Server databases (2008/R2) after development and testing to a productiv/live platform? What are the requirements and permissions it needs, so the topic Deployment, Support, Database update not turn into a nightmare.=> What should I consider (Compare, Synchronice, Server Roles, Database Roles) so that a DBAdmin can live with that ..... :)I have to deploy (Database with Tables, Views, StoredProc., Functions)Thank youKind regardsNicole ;-)Thu, 27 Sep 2012 00:30:29 GMTinfo 58414