not able to INSERT or UPDATE table

  • As I said, I kow it's possible, but not without extensive permissions (which could be used by hacker) and having to do some gymnastics to call the process from outside the trigger.

  • I completely understand what you are saying, but to do that, we would have to pay an addition $5000 just to have that done. I know that I can do it from SQL Server and would like to, it's just a matter of figuring out why this isn't working.

  • You don't have access to the application and need to have it modified outside of your office?

  • Exactly, we paid all kinds of $$$ for this software and now, come to find out, it honestly just isn't up to par. we don't feel like feeding the CEO of their business for another year out of our own pocket.

  • Well in that case... The safest way to handle this is too create a table with a single line with a flag.

    When the trigger is called, update the flag to yes/on or 1 (whatever).

    Then have a job run every 2 minutes (shortest allowed interval) that check if the flag is on. Then if it's on, exec the bat file.

    If you need a shorter interval it can be arranged too.

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply