Register | Login

Stacking Code

public interface IBlog { string Dump(Stream consciousness); }

SQL Server 2008 Express Sysadmin

Thursday, 30 June, 2011 @ 11:08 AM < Adam Boddington
Tags: SQL Server, Visual Studio

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.

There are 0 comments.


Leave a Comment

Please register or login to leave a comment.

PowerShell I Should Already Know

Handy PowerShell to Find Maximum File Sizes

PowerShell I Should Already Know

Handy PowerShell to Find Maximum File Sizes

browse with Pivot



Building Neno

Recent Posts

Codility Nitrogenium Challenge
OS X Lock
HACT '13
Codility Challenges
Priority Queue


Architecture (13)
Brisbane Flood (1)
Building Neno (38)
C# (4)
Challenges (3)
Collections (1)
Communicator (1)
Concurrency Control (2)
Configuration (1)
CSS (5)
DataAnnotations (2)
Database (1)
DotNetOpenAuth (2)
Entity Framework (1)
FluentNHibernate (2)
Inversion of Control (5)
JavaScript (1)
jQuery (4)
Kata (2)
Linq (7)
Markdown (4)
Mercurial (5)
NHibernate (20)
Ninject (2)
OpenID (3)
OS X (1)
Pivot (6)
PowerShell (8)
Prettify (2)
RSS (1)
Spring (3)
SQL Server (5)
T-SQL (2)
Validation (2)
Vim (1)
Visual Studio (2)
Windows Forms (3)
Windows Service (1)


Powered by Neno, ASP.NET MVC, NHibernate, and small furry mammals. Copyright 2010 - 2011 Adam Boddington.
Version 1.0 Alpha (d9e7e4b68c07), Build Date Sunday, 30 January, 2011 @ 11:37 AM