http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/6009.aspxMon, 03 Nov 2008 08:56:34 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6009rsocol0http://sqlserver.ro/forums/thread/6009.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6009Dacă este vorba doar de <i>database roles</i>, atunci ele vor fi mutate automat împreună cu baza de date, dacă faci backup/restore sau dettach/attach (inclusiv user-ii, permisiunile, etc). Singura chestiune în acest caz ar putea fi maparea între login-uri şi user-i, pentru care vezi link-ul de mai sus referitor la "orphaned users".<br><br>Răzvan<br>http://sqlserver.ro/forums/thread/6008.aspxMon, 03 Nov 2008 08:02:40 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6008Alex0http://sqlserver.ro/forums/thread/6008.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6008<P>este vorba despre database roles....</P> <P>multumesc</P> <P>alex.</P>http://sqlserver.ro/forums/thread/6003.aspxFri, 31 Oct 2008 16:21:12 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6003B_gd_n[ ]Sahlean0http://sqlserver.ro/forums/thread/6003.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6003Înainte &gt;<a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&amp;displaylang=en"> Microsoft SQL Server 2005 Upgrade Advisor</a><br><a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;246133">How to transfer logins and passwords between instances of SQL Server</a>http://sqlserver.ro/forums/thread/6002.aspxFri, 31 Oct 2008 16:11:55 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6002rsocol0http://sqlserver.ro/forums/thread/6002.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6002Pentru migrarea login-urilor (inclusiv parole), vezi:<br><a href="http://support.microsoft.com/kb/246133">http://support.microsoft.com/kb/246133</a><br><br>În privinţa rolurilor, e vorba de server roles sau de database roles ?<br><br>Vezi şi:<br><a href="http://support.microsoft.com/kb/314546">http://support.microsoft.com/kb/314546</a><br>(mai ales secţiunea referitoare la "How to resolve orphaned users")<br><br>Răzvan<br>http://sqlserver.ro/forums/thread/6001.aspxFri, 31 Oct 2008 15:14:41 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6001Alex0http://sqlserver.ro/forums/thread/6001.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6001<P>salut</P> <P>am un server de 2000 si unul de 2005 (de test). am montat bazele de pe cel de 2000 pe cel de 2005.</P> <P>Vreau sa mut si <STRONG>rolurile</STRONG> si apoi <STRONG>useri+parole+rolurile</STRONG> <STRONG>din care fac parte</STRONG></P> <P>Cum pot face asta cat mai rapid.</P> <P>multumesc mult.</P> <P>alex.</P>