The complete scenario here: http://blogs.msdn.com/b/sqlexpress/archive/2010/02/23/how-to-take-ownership-of-your-local-sql-server-2008-express.aspx
One excellent script solution here: http://archive.msdn.microsoft.com/addselftosqlsysadmin/
NOTE: if you happen to have a non-English windows version (as I do), you will have to modify the script, since it relays on command outputs that are language dependant.
No comments:
Post a Comment