CREATE TABLE [dbo].[MYTABLE] (

[MYDATE] [smalldatetime] NULL ,

[MYDEPT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[MYNUMBER] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[MYAMOUNT] [int] NULL ,

[MYTOTALAMOUNT] [money] NULL

) ON [PRIMARY]

GO

Thanks

Thank you,

It does return the required results.

Data type is char(12) does not allow nulls .

Eg of a few primary keys...

3BQWDL0000K0

3BQWEB0000K0

3BQWEX0000K0

Is there any formula behind it that is generating this ? If so how do I find...

Thanks..But the issue is I would like to track the changes that have already been done . Not from now. Basically I want to track the past. Any thoughts .

Thanks!

Yes exactly I want to trace the activity of a particular database role(StoredProcExecutor) .Audit everything for the past week . Who used it etc.I am looking for something easier other...