• Sorry, I am about to leave for an international trip and probably won't be able to assist effectively. Possible things to look into are:

    1) Permissions. If this is development or not worried with security make your app log in with SA level access and see if that works.

    2) You REALLY need to be able to collect server activity via profiler (or Extended Events) to see what is happening. My seeing your outside-SQL-Server code is useless because it doesn't confirm to me the actual calls or effects or errors being caused inside SQL Server from that code.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service