Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to firstname.lastname@example.org.
On Tue, 28 Apr 2009 09:20:13 +1000, "Arthur Barrett" <arthur.barrett at march-hare.com> wrote: > >> Try this (tested on a CVSNT repo audited by MSSQL Server, but the >> command should be almost identical: >> >> SELECT Command, [Date], Username, Hostname, VirtRepos >> FROM SessionLog >> WHERE >> (Command='update' OR Command='checkout') >> AND ([Date] > '2006-01-05') >> AND ([Date] < '2006-02-01') >> >> Notice the brackets surrounding Date, needed on MSSQL since Date is a >> reserved word and here is also defining a column name. > >I think that we changed column name that in CVSNT 2.5.04, so that SQL is >probably for 2.5.03.2382? > I have 2.5.04.3236 on the server where I tested this SQL on. If I check SchemaVersion it reports 3, whatever that means. Of course the test server has "always" had Auditing running but not a lot of traffic (only me when I was testing out stuff) and it might be that I never updated anything in the Audit tables. What is your script SQL for updating an MSSQLServer database? I mean the text of the update script, so I can see what may be possible to do? -- /Bo (Bo Berglund, developer in Sweden)