Stacking Code

If someone else has installed Visual Studio 2010 on your machine for you then you'll probably find they've been granted sysadmin on the local SQLEXPRESS instance by default. Even if you're an administrator on the machine, you won't be able to do much with it until whoever did the install grants you permission.

If you can't be bothered tracking them down, there's a way to take back ownership yourself. Ward Beattie wrote a handy little script that will grant sysadmin to you if you're a machine administrator. You can find it here, and read more about what is going on here.