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 |
|
adnanans78
Starting Member
17 Posts |
 Posted - 2007-08-27 : 05:24:18
|
| Hi,I m new for creating trigger.I want to create trigger on a database intead of every table.I created a table containing 25 collumns to store changes are make on triggers fire.Is there possible i create single trigger and save all changes in a seprate table?Plz wirte a trigger for this senerio.Thnx in advance. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-08-27 : 05:27:18
|
database trigger only available in 2005 onwards
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
adnanans78
Starting Member
17 Posts |
Posted - 2007-08-27 : 06:13:55
|
| Hi,Thanx for reply.Ok let me know create trigger for on table and changes insert all changes into an other table even i do not know how many attribures are changed.Hope any will write in this context.Thnx in advance. |
|
|
|
|
|
|
create Trigger