I am using SQL server 2008 R2, on my development machine. I had to delete
the old windows user account, with which I had installed SQL Server.
I have created a new admin account. When doing any DB related work in Visual Studio with new user, I get DB Access denied error on master table.
As this is basically for development purpose, I need most elevated permission for this user.
How do I grant
a windows user admin rights to all the tables?