Running a stored procedure that updates a static table

[walker121]

I have a problem where:

A user wants to specify when a table gets updated on demand. Can this be achieved?

The SP executes, and you get no errors returned, but somehow when you check, no updates / inserts or deleted happened?

[anil.kumar]

Are you using commit inside proc ?

[walker121]

no we are not using commit. Only Begin and End at the beginning and end of the SP

[anil.kumar]

This might be the reason as we don't call commit when queries are executed using exec so proc should take care of commit.

[walker121]

the proc runs inside sql server management studio as expected.

[anil.kumar]

Management studio might be calling commit automatically when proc done. IN BI+ query are not supposed to change data so we don't call commit at all.

[walker121]

so i am guessing the only work-around to this issue is using a dummy ETL process ?