Aye, it even says so in books online. 

The important part tho is that the log can be truncated/backed up at frequent intervals during...

Pretty sure these are logged ops.  Indexdefrag afaik is not a single transaction though - so the log can be truncated/backed up during the operation. The other 2 on the...

'salright. 

Putting a gig and a half a day into this table at the mo, 4 months into what looks awfully like exponential growth.

Its nearly 130Gb so, I think condolences will be required shortly...

how about

select Cia, Emple , (select top 1 balance from table b where b.Emple  = m.emple and b.cia=m.cia where date <= @date order by date desc) from table m

or somehting along those...

check out CONVERT in BOL - see if any of those formats would work for you!

how about raiserror(...) with log?

write a function and reference the function in the constraint.

eg constraint check (dbo.BobIsRight(colname1, col23) = 'True')

can you not simply use right('0000000' + ltrim(str(run_time)), 6) or whatever it is?

something along the lines of

select

cast(

ltrim(str(run_date))+ ' '+stuff(stuff(right('000000'+ltrim(str(run_time)), 6) ,...

Daft question, but is it actually set up as a network share? 

Are you using any filters?

A lot of the folks I've worked with often call the retained transaction log backup files 'log files'.  I admit I often do myself....

With the av - is it running some heuristics/real time wotnot?  Also did you manage to get an exemption for the import location - or is that all being scanned too?

Another...

Hi

Sounds like fun...

The main things in my experience to cause these are Transaction Log size (being big - anything over a couple hundred meg or so is indicative of a...

Check out OBJECTPROPERTY in BOL.

Rich