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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply