Active Directory Change Tracking

Question

Hi Guys,

I am going to develop an application which will monitor changes in Active Directory. I will either use Change Notification control or DirSync control. I want to track the What, Who, When , Where of each changes. I can get What ( is changed) by using any of the technique( change notification or DirSync), but none of these technique tells us that who made the changes, where changes were made and When. Can you please let me know any way to find out these information about each change?

I know one solution could be to turn on domain controller auditing and read these infromation from event logs, but i don't want to use this approach.

Thank You
-Akhtar

Answer 1

SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[YourTable]') if it exist then it will display the result,,,with table name ,,,tpe and everything

Answer 2

Select your database and open new query window and

EXEC sp_tables @table_type = "'table'"

Answer 3

hi,

there are two tables sys.tables and sys.objects, in which data base maintain table information
please try.

select * from sys.tables where name = 'Table1'

select * from sys.objects where type = 'U' and type_desc = 'USER_TABLE'

hope this will help you.