there's no direct way to append to the top of a file;

you have to do it in this order:

1.create a new file. with your Filesystem object

2.write the new stuff to...

After Dave inferred that it was the # seconds since 01/01/1970, it was pretty easy...but how the heck did he figure out the starting date?

Dave had you tripped over...

the script below might help a little;

Assume you grab your 200 backups in a number of folders/subfolders.

you probably need to RESTORE HEADER ONLY to see the DatabaseName that is associated...

I'm a little confused by the question;

a script to backup all the databases is very easy, and so is putting it in a job so it runs on a regular...

kabaari (8/18/2009)

---

I am using Coldfusion to INSERT and SELECT data. I used a to do this:

When I <cfdump> this, it works. The empty values return [empty string]. But when...

my pleasure; something like this is much easier to understand visually like that. glad i could help.

here's something to help visualize it:

Dave Ballentine showed you step by step how the conversion is going to work; but if you use the final answer, you don't get the timne portion, just the correct...

Yes = You meant something else?

or

Yes = That was the solution i was looking for?

ok if there could be multiple spaces before the period,

here's how i would do it: i thought about STUFFing it, but relized there's a simpler solution:

i would simply grab the...

if you mean when you copy and paste from Management Studio to Excel, it's an option you'll want to turn on:

did you mean something else?

conversions like this are a pain; obviously, whenever possible, this kind of data should be placed in a datatime filed, instead of a varchar/char; if you can, convert your original...

ajith.ranjan (8/17/2009)

---

Thanks Lowell

Your code worked for me. Next step is I have to workout how to pickup one file at a time from the directory.

It is great if...

why does it fail though? I'm speculating that the constraint is merging the INSERTED and the DELETED rows to get the count or [INSERTED] and [tbl], so it finds...

your example was interesting!

I see how that fails, when I'd obviously think that was jsut fine...That's what you mean about having to test the business condition in the trigger instead,...