Thanks MM.

Bit by Azure again. Man, I really need to talk my company off SQL Azure. It is just too limited right now. Anyone out there looking to move to Azure, DON'T DO IT if your app depends on ANYTHING other than DML, DDL. It's just not there yet.

The local server -> Azure server is a thought. Probably ought to just stick with a basic solution and create a web role I guess. Thanks for the help all!