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 |
|
andreiph
Starting Member
3 Posts |
 Posted - 2011-03-14 : 21:39:34
|
| Hi,This might have been asked before but I can't seem to find an answer (or a simple answer that I'd understand). We ran a report and managed to get all the updatedtable by a specific user including the timestamp. Is there any way to check which column's been updated?Cheers!Andrei |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-03-15 : 06:10:37
|
quote:
We ran a report and managed to get all the updatedtable by a specific user including the timestamp.
Can you elaborate a bit? What kind of report? And the "updatedtable"...is this the updated virtual table that is exposed in a trigger?- LumbagoMy blog-> http://thefirstsql.com/2011/02/07/regular-expressions-advanced-string-matching-and-new-split-function-sql-server-2008-r2/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-03-15 : 10:26:11
|
| Seems that you may need to use a triggerMadhivananFailing to plan is Planning to fail |
|
|
|
andreiph
Starting Member
3 Posts |
Posted - 2011-03-15 : 16:57:07
|
quote:
Originally posted by Lumbago
quote:
We ran a report and managed to get all the updatedtable by a specific user including the timestamp.
Can you elaborate a bit? What kind of report? And the "updatedtable"...is this the updated virtual table that is exposed in a trigger?
It's pretty much any table being updated. So I'm guessing there's no system table that I can look up without triggers at the design of the DB.Thanks. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
andreiph
Starting Member
3 Posts |
Posted - 2011-03-15 : 17:58:48
|
quote:
Originally posted by X002548
UNLESS you have programmed something, then, no
thanks mate |
|
|
|
|
|
|
Updated Tables, Columns.