Comments by RemcoReitsma

RemcoReitsma 18-Feb-15 16:09pm View

I guess it depends on the options you have. I mean I have come in scenario's where I was given a product from some third party with no source code and only a database to work from and I was not allowed to change anything in terms of permissions and changes in configuration except on the database.

What if the client does not want other software installed like SSIS or Windows services?
When you look at the original question then you can see that there is not to much to go on, but I felt that knowing about the trigger alternative is useful.

SQL Server agent would ofcourse be an obvious choose, but as you can see from the MSDN site it's not that straightforward and may not even be allowed in terms of permissions.
https://msdn.microsoft.com/en-us/library/ms178142.aspx

I'm not arguing if using triggers is the best solution, but it is an alternative.
If you want to use saying than I would be pragmatic and say "use the tools that were given to you"

RemcoReitsma 15-Dec-11 1:28am View

Deleted

Don't forget to vote up if you like the tip ;-)

RemcoReitsma 14-Dec-11 22:17pm View

Deleted

I have added a small example to the article which would help you hopefully

RemcoReitsma 18-Jul-11 21:49pm View

Deleted

Hmm something got messed up during copy and paste because for some reason the dynamic got removed and at the end of the code block suddenly a </dynamic> appeared.

Anyway it should be sorted now

RemcoReitsma 18-Jul-11 15:02pm View

Deleted

I've updated and simplified the code.
There was indeed a bug when it hit the <tables> node because the skip variable was not set to true. Also the code was too messy and had a redundant while loop.

It looks to be working okay now, so have another try :)

Comments by RemcoReitsma (Top 5 by date)