| Author |
Topic |
|
grandhi
Starting Member
31 Posts |
 Posted - 2013-05-23 : 06:31:37
|
| Hi All, I have a DB with hundreds of tables.If any table is modified inside DB,my next computations will be happen.So How can I check any table is modified or not inside DB,for this is there any query.can anyone help me?Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-23 : 06:33:35
|
| By table modified do you mean a DDL or DML operation? Anyways generally you can use a trigger to implement a logic based on an action performed on a table.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
grandhi
Starting Member
31 Posts |
Posted - 2013-05-23 : 06:39:31
|
| I want to know status of the DB in both cases (DML,DDl).I don't know trigger concept.Anyway I will check it in Google. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-23 : 06:51:06
|
quote:
Originally posted by grandhi
I want to know status of the DB in both cases (DML,DDl).I don't know trigger concept.Anyway I will check it in Google.
What all information you want to capture for each event? just generic info like time,process owner etc or more specific like column affected,data etc?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
grandhi
Starting Member
31 Posts |
Posted - 2013-05-23 : 07:33:02
|
| @visakh16 before seen your answer,Exactly I don't know,which type of information was useful for finding,when Db modified like any operation making new tables,updating,deleting,inserting rows.after seen your answer I hope time is enough,what you sayis there any information was more efficient compared to time.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-23 : 07:37:56
|
quote:
Originally posted by grandhi
@visakh16 before seen your answer,Exactly I don't know,which type of information was useful for finding,when Db modified like any operation making new tables,updating,deleting,inserting rows.after seen your answer I hope time is enough,what you sayis there any information was more efficient compared to time.Thanks
sorry that really depends on your requirement, so I cant say you might need time alone.Which version are you using? Have you considered Change Data Capture, Auditing etc?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
grandhi
Starting Member
31 Posts |
Posted - 2013-05-23 : 08:04:34
|
| I am using Ms SQLSERVER 2012,I am new to Database side,so can you explain clearly what is change data capture,Auditing.I read some blogs,what you posted in Facebook.I didn't understood anythingThanks for your help. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-23 : 10:07:22
|
| Change Data Capture is method by which database automatically captures data changes happening on set of tables.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
How to check status of the DB ?