sqlserver hooking process

[abcdefgqwerty]

If you can hook any process pretty much is it possible to hook the sql server process? Could you then run any code in that process address space with maybe like .dll? why wouldnt this work?