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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-01 : 08:23:14
|
| Phil writes "Is there a way, through a trigger or something, that upon a table/SP change or creation SQL mail can generate an email message? If anybody knows a way to do this, can you post a specific message or direction I can look towards for more information?Thanks,Phil" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-01 : 12:41:02
|
| Why would you want to track this information? Just have the developers notify you are have them upload the changes in VSS and then deploy from there.You would have to create a trigger on a system table in order to be able to track this, which is highly not recommended.Tara |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-01 : 20:43:20
|
| And you can't create triggers on system tables anyway.Better to CONTROL the alterations like Tara suggests, than to be notified about them afterwards. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-02 : 03:20:37
|
| And if you're worried that someone will sneak in a change without telling you, don't give them permissions to create objects, but retain this for yourself.--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
|
|
|
|
|
|
SQL mail and a change to a database