I was migrating an old WSS 2.0 site on SQL 2000, to WSS 3.0 on SQL 2005, and didn't like where the default databases were being created.
I detached the databases, moved them to thier new location, and re-attached them.
This changed the owner from "NT Authority\Network Service" to my account.
I used the following SQL code to change the owner back:
USE whichever_database
EXEC sp_changedbowner 'NT Authority\Network Service'
Thanks to Kalen Delaney for that!
I detached the databases, moved them to thier new location, and re-attached them.
This changed the owner from "NT Authority\Network Service" to my account.
I used the following SQL code to change the owner back:
USE whichever_database
EXEC sp_changedbowner 'NT Authority\Network Service'
Thanks to Kalen Delaney for that!
No comments:
Post a Comment