Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
valisnow
Starting Member
1 Post |
 Posted - 2011-03-29 : 10:12:14
|
| Hello,I am running SQL 2008 and Team Foundation on a WS2003 R2. I had to join the server to another domain and now, no database has an owner...from here a lot of errors. That`s normal since the previous user was from the previous domain. The question is how can I use an account from the new domain to take over all the rights of the previous one?Thank you very much for your help.CDV |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-03-29 : 14:36:34
|
| Try thisALTER AUTHORIZATION ON DATABASE::OldLogin TO NewLoginPBUH |
 |
|
|
|
|
|
SQL 2008 and Team Foundation