Ok guys, the solution was:

1. Create a new user in windows with admin rights and log into that account.

2. Start SQLServer in single connection mode. Link

3. Connect to Managment Studio...

Sweet! That seems to be the way to go, gonna try it out later when the traffic gets lower and i can shutdown the server.

I'll update and tell how how...

And this is my question... If you have rights to Disable it, it means you have to rights to Enable it back. Just UNDO your step.

OR

Do you have any other...

Basically i had all the standard install accounts like sa, nt authority and the like enabled.

I accidently disabled login for my windows account named "Administrator".

And i dont remember the password...

I dont remember the password for sa, but i am dba, running the server on local machine.

I dont have access to sysadmin account... except maybe NT AUTHORITY\SYSTEM.

IS it possible to log into Managment Studio with NT AUTHORITY\SYSTEM...

Is there a way?

I would need to access NT AUTHORITY\SYSTEM to enable admin again...

I accidently disabled admin acc, and dont have access to sa...

@Suresh Ty, you were right once again.

I found it useful to use: set @Subject_tets = 'some text' + @variable + 'some text', instead of having it in the select clause.

New day, new challenges...

Here's how the script looks like, as it is now i create a temp table and populate it with data (id,email, firstname), then it loops through every...

@suresh

That did the trick, thank you!

Now it works to send emails to several recepients, however it doesnt seem very scalable... next step, figure out how to create a loop that...

@Derek

Thats pretty much the options i got, either write a ASP VBScript app or use Database Mail together with SSA Jobs... Trying to figure out wich one...