Hi all,

Thanks for the feedback.

I'll try and answer all the questions here.

abarber - I have made the changes and bug fixes you suggested, however I'm not sure how to edit the script once I do I'll add the changes

Dugi - What help would you like?

billrossbillross- Here is an example of how to use this:

[font="Courier New"]CREATE TABLE AuditTester

(

col1 VARCHAR(10),

col2 NVARCHAR(10),

col3 CHAR(10),

col4 NCHAR(10),

col5 INT,

col6 DECIMAL(10,2),

col7 MONEY,

col8 FLOAT)

EXEC [dbo].[pAutoAudit]

@DATABASE  = 'test'

, @TABLENAME = 'test'

, @SCHEMA = 'dbo'

, @AuditDATABASE  = 'testAudit'

, @AudiTABLENAME  = 'testAudit'

, @YourName = 'Christopher Stobbs'

, @VinJobNo = 1234

, @VbtComplex = 0[/font]

asifejaz - What other details would you like to know?

Have you run the script? If so then seeing the results will give you an understand. If there is more you want to know please let me know.

pramod bura - Please post the CREAET TABLE structure here so I can see why it isn't working.

Thanks all

Chris