Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jay1
Starting Member
17 Posts |
 Posted - 2008-09-29 : 08:25:41
|
| I was wondering if you could help me I need sql script that sends an alert/notification if the table has more tha t 400 records. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-29 : 09:00:46
|
You can write a trigger for this if you want instant notification.Otherwise you have a sp scheduled with a job to run nightly.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
jay1
Starting Member
17 Posts |
Posted - 2008-09-29 : 10:43:37
|
| I needed the script for the instant notification. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-29 : 10:47:12
|
Write a trigger then.Books Online has numerous examples of this.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Rows insert alert