May 27, 2021 at 9:29 am
How to setup a monitoring where it throw an alert whenever a field data type value is about to reach its maximum limit.
May 27, 2021 at 9:38 am
How to setup a monitoring where it throw an alert whenever a field data type value is about to reach its maximum limit.
Please give an example of what you mean.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
May 27, 2021 at 3:10 pm
If, for example, you're trying to determine that, say, an int value is nearing 2,147,483,647, then you could use an UPDATE trigger for that.
If not along those lines, then, as Phil stated, please give examples of what you mean.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
May 28, 2021 at 7:33 am
@scottpletcher, yes. You are correct.
For example:
If I declared a field as Numeri(10,5), and inserting data through some job. When the data reached maximum allowed range for this column, I need to get notified.
May 28, 2021 at 2:34 pm
Then, as I stated before, you would need to put an UPDATE trigger on that table.
One trigger could handle all of the numeric, date, etc. columns in a table.
The triggers should be static but could be generated dynamically. In fact, this will be vital, as you wouldn't want to have to write all these triggers by hand.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply