Heh... this is where I cheat like hell... everything is possible if you have the imagination for it... remember, before you can think outside the box, you must first realize...

Any feedback on this? Did it do what you wanted?

In that case, you can either use BCP with a format file that uses \" as part of the delimiter ("," would be "\",\"" in the delimiter column,...

No... haven't used C2 Auditing... I forgot about that... might also be interesting to try.

That brings up an interesting point, Jack... I wonder if you can make a Trigger that has DDL Trigger associated with it and between the two, make it impossible even...

I've read about it and it just makes sense to me. The whole idea of set based processing is to make the paradigm shift from thinking about what to...

Just my 2 cents...

I agree... having a default on the "Created" columns does the job for those... but, there's a catch... what happens if someone tries to UPDATE those columns?...

Greg...

What do you want to see for output?

Tom,

Just curious... Are you saying that "CM" is the abbreviation for "Customers" and that "CA" is the abbreviation for {customer}"Addresses"?

I s'pose those are OK questions... there isn't a one in there that will help you figure out if you have an SQL Developer on your hands, though.

And that's part...

BCP will not import .DBF files. You'll need to use DTS for that. Or, you can use a linked server or OpenRowSet with the .DBF provider to link...

Sure... that would be a good start... I guess I'd set up the following alerts... of course, you have to know what's right for your system or you'll be up...

Heh... sounds like you're trying to build an electronic DBA... it would be cheaper in the long run if you just hired one. Seriously... 😉

Heh... it's not that complicated... why not just use BCP in the Native mode? If you just gotta have something to look at, it's still not that complicated... ...

Heh... I know... not a problem, Michael... just having a bit of fun 'cause you used the "C" word 😛