Hi David,

I like the idea of the article but had a problem when I put it on our developer machine

after running your test the results I got from other developers came out like this:

IDCommandPostTimeHostNameLoginName

1UPDATE STATISTICS tbluser 2008-10-02T08:51:07.563NSSLT5NSSDEVSQL\rcsnslenzti

2CREATE TABLE dbo.Test(col INT) 2008-10-02T08:51:07.640NSSLT5NSSDEVSQL\rcsnslenzti

3DROP TABLE dbo.Test 2008-10-02T08:51:07.670NSSLT5NSSDEVSQL\rcsnslenzti

4--ENCRYPTED--2008-10-02T09:49:14.767NSSDEVWEBNSSDEVSQL\RCSNETUSER

5--ENCRYPTED--2008-10-02T09:49:14.827NSSDEVWEBNSSDEVSQL\RCSNETUSER

6--ENCRYPTED--2008-10-02T09:49:14.843NSSDEVWEBNSSDEVSQL\RCSNETUSER

7--ENCRYPTED--2008-10-02T09:49:14.877NSSDEVWEBNSSDEVSQL\RCSNETUSER

8ALTER TABLE dbo.tblVIFixes ADD test nchar(10) NULL 2008-10-02T11:47:51.767NSSLT5NSSDEVSQL\rcsnslenzti

I ran a check by opening a table and adding a column test and then ran the query again. This gave me the newest line 8

My question is what would give the --ENCRYPTED-- response?

I hope to get this working to track changes undocumented by developers!

Thanks,

Tim