Ya gotta trust me on this one, Ben... things like the following tidbit have been tested, tried, and trued by me and about a thousand other folks on this and...

Koji,

Thanks for posting your solution... THAT's what we like to see when folks get things working!

Heh... know wurrees, Ed... A've bin nown too meke na tyyp-oh hear ond their, meself

Heh... obviously not a "precise" number, eh?

After seeing all the stuff about rounding on these interminable threads, I've decided I'm not rounding anything...

Krissy,

How big are the hard-drives associated with the datafile?  The other question would be, how many months or years does the current 60 gig of space used represent?  The reason...

No...

Each temp table is actually named a bit differently but is transparent to the user... for example, if you have a temp table named #MyHead in a proc, each session...

Ok... first the "party line"   This type of formatting should NOT be done in SQL Server... it should be done in the GUI...

Already posted this on the PM you sent me... thought I'd share the solution I think you are looking for...

CREATE TRIGGER Flag_update

on table_A

for update

as

if Update (Table_A.[Date])

 Begin

  update table_B

  Set Flag =...

Mostly habit, Andy... I heard (a very long time ago) that the sp_OA routines had memory leaks (never did test to find out if that was true, my bad) and got...

Sab,

Would you mind showing us the code you've tried so far, please...

-- Sorry, Jeff. Just to make it repeateble for everyone.

Ack!   I...

Have you tried anything, yet?

Heh... I like it!  Simple math... everything in the universe ultimately rounds to zero... with or without bankers rounding!   (Unless you're gonna round...

The log file will not grow that large if you do regular backups.  Setting a 1 gig log file may cause your server to come to a sudden halt if...

Heh... yeah, some naming standards seem appropriate.  Don't let them use blanks in their names, either.