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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2009-05-19 : 00:03:29
|
| I can turn on the blackbox and read the trace files to see who using the sa. If i do not move the files they will get overwritten when they reached their size. Anyone got any other suggestions when someone logs in as sa i want to know where this is being called from and who running x.Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-19 : 00:11:42
|
Logon Triggers ?http://msdn.microsoft.com/en-us/library/bb326598(SQL.90).aspx
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-19 : 23:46:25
|
| Looks interesting the trigger..will it capture the sql statement or just that the user logs on. Perhaps i can get trigger to fire email what do you think then i can go on sql and see the statements |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-05-19 : 23:53:39
|
quote:
Perhaps i can get trigger to fire email
Not a very good idea to do this. Should do it in a separate process.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-20 : 14:09:02
|
| So with the trigger when it fires it will write to the error log or only if this is coded in.I do not want to prevent any access as it is the sa login. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-20 : 15:46:26
|
Logon triggers detects "EXECUTE AS"?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
tracking who using sa