For those moments where you can only get access via osql.exe....
CREATE LOGIN [Domain\UserName] FROM WINDOWS;
GO
EXEC master..sp_addsrvrolemember [Domain\UserName],'sysadmin'
GO
Why yes. I did just lock myself out of a server accidentally this morning. Where Management Studio wasn't installed. Go figure.
Wednesday, 12 October 2011
Subscribe to:
Posts (Atom)