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 |
|
kiranmurali
Yak Posting Veteran
55 Posts |
 Posted - 2011-05-24 : 09:00:42
|
| Hi,i have one senario, i have to create audit table which should contain all the fields same as the userdefined table , my only request is audit table should not create unique keys,but my source table will have the unique keys.can any one help to solve this.Thanks in Advance,kiran murali |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-05-24 : 09:22:30
|
| In SQL Sever Management Studio, find the table in object explorer, right-click, select "Script table as -> Create to -> New query editor window". Then, make appropriate changes to create the audit table.Once you have the audit table created, you would probably do the audit using a trigger for update, delete, and/or insert based on your requirements. |
 |
|
|
kiranmurali
Yak Posting Veteran
55 Posts |
Posted - 2011-05-24 : 09:28:30
|
| Thanx a lot. |
|
|
|
|
|
|
AUDIT TABLE