Wednesday, July 18, 2012

HOW TO: take ownership of your local SQL Server 2008 Express

So, you have administrator privileges on your machine but you don't have ownership over your SQL Server 2008 Express instance. How can this even be possible? ... actually is quiet simple, you just have to create your SQL Server 2008 Express instance with a different user to the one with which you are logged in, that's all, sad and simple.


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.