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 |
|
wombel
Starting Member
14 Posts |
 Posted - 2002-07-18 : 04:00:42
|
| Hi,I want my sql-server to inform me, whenever an "alter table" or "create table" is excuted. I thought it might be a good idea to use the alerts of the sql server agent for that, but did not find an event number for it. Can anyone help me with that?TIAThomas Wrobelwaslos.deThomas WrobelSenior IT Manager |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-18 : 08:46:26
|
| That's a pretty cool idea, unfortunately alerts only work with errors or performance events.You can create a profiler trace for SQL commands, but it doesn't appear you can limit it to ALTER/CREATE TABLE only. You'd get every SQL statement, and then you'd have to filter through them looking for the ones you want, THEN fire off a job to send the actual alert.You *might* be able to create a custom error message that can take advantage of the SQL Server alert system, but I can't see how to attach it to a CREATE or ALTER TABLE statement.Sorry I couldn't be more help. You may want to try these companies:http://www.lockwoodtech.comhttp://www.red-gate.comThey have some database auditing tool that might be able to do what you're looking for. |
 |
|
|
|
|
|
Error number for create/alter table