Monday, March 30, 2015

nop.exe

#pragma comment(linker, "/SUBSYSTEM:windows /ENTRY:mainCRTStartup")
void main() {
;
}
view raw gistfile1.cpp hosted with ❤ by GitHub
nop.exe
C:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\vcvarsall.bat
Cl nop.c

add windows user to sql instance in single user mode

"D:\Microsoft SQL Server\<INSTANCE_NAME>\MSSQL\Binn\sqlservr.exe" -s<INSTANCE_NAME> -m
wichtig parameter für sqlcmd sind case sensitive
sqlcmd -E -S<SERVERNAME>\<INSTANCE_NAME>
CREATE LOGIN [<domain>\<user>] FROM WINDOWS;
GO
SP_ADDSRVROLEMEMBER '<domain>\<user>', 'sysadmin'
GO