http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/4874.aspxTue, 13 May 2008 12:05:24 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:4874ThePuiu0http://sqlserver.ro/forums/thread/4874.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=4874ok, multumesc tare mult!http://sqlserver.ro/forums/thread/4873.aspxTue, 13 May 2008 11:42:22 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:4873B_gd_n[ ]Sahlean0http://sqlserver.ro/forums/thread/4873.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=4873O posibilă soluţie:<br><span style="color:Black;background-color:transparent;font-family:Courier New;font-size:11px;font-weight:normal;"><span style="color:Blue;background-color:transparent;font-family:Courier New;font-size:11px;font-weight:normal;">ALTER</span> <span style="color:Blue;background-color:transparent;font-family:Courier New;font-size:11px;font-weight:normal;">AUTHORIZATION</span> <span style="color:Blue;background-color:transparent;font-family:Courier New;font-size:11px;font-weight:normal;">ON</span> <span style="color:Blue;background-color:transparent;font-family:Courier New;font-size:11px;font-weight:normal;">SCHEMA</span>::[db_owner] <span style="color:Blue;background-color:transparent;font-family:Courier New;font-size:11px;font-weight:normal;">TO</span> [username]</span><br>http://sqlserver.ro/forums/thread/4872.aspxTue, 13 May 2008 11:34:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:4872ignatandrei0http://sqlserver.ro/forums/thread/4872.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=4872Poate<br>sp_addrolemember&nbsp; @rolename =&nbsp; 'db_owner' ,<br>&nbsp;&nbsp;&nbsp; @membername =&nbsp; '...'<br>http://sqlserver.ro/forums/thread/4871.aspxTue, 13 May 2008 11:09:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:4871ThePuiu0http://sqlserver.ro/forums/thread/4871.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=4871<P>Salut! Dintr-o aplicatie vreau sa creez automat o noua baza de date (clona uneia existente) intr-un server sql 2005 express. Am generat scriptul care creeaza baza de date si cel care creeaza structura de tabele, proceduri, utilizatorii, etc. Problema e ca dupa creeare totul este ok, mai putin faptul ca userul nu are setata in 'database role membership' proprietatea db_owner. Cum pot sa setez automat si asta folosind tot un script?</P> <P>Multumesc anticipat!<BR>Puiu</P>