Actually, that's for a different purpose --- the intention with that one check is to log any query that takes too long. Think of it as a client-side performance tracing....

I don't believe Access manages this directly; it defers to the ODBC Manager & Driver for...

I want to point out that the only time such criteria would make difference is when the join is an outer join rather than inner join because when criteria is...

capnhector -

In this hypothetical example, it was assumed that a customer could have several accounts and orders are related to accounts for budgeting purposes. In this situation, we shouldn't store...

Sean:

I certainly do agree that we're doing more work on the inserting new rows to Child tables and that also allows for more errors (e.g. trying to insert wrong...

I'd have agreed if the updates required additional work (e.g. manually updating grandparent key in both parent and child table) but the schema I demonstrated does that via ON UPDATE...

It'd have been nice to not have to use GO between certain DDL and DML statements. That would have made things more simpler. Oh, well.

GSquared,

Yes you nailed it as I explained in my subsequent discovery in my previous post just before your last reply.

Again, thank you!

GSquared,

I was going to say that I had disabled a trigger as part of the change script but you made me go and look again and turns out there's one...

The actual table is more complicated than that but that is in fact the gist of the definition of pertinent columns. The ID is an identity, and the actual table...

Yes, I observed this, but my concern was that this amounts to using a magic numbers which may work today but not tomorrow. I have the same problem with "name...

Thanks but this still includes the 'sa' and '##...##' logins and I don't see any columns that would indicate if the login is a builtin login or not.

Cool. Thanks for sharing your viewpoint. I can see the advantage of being able to separate constraints from columns. In my use case so far (and who know, it may...

Thanks Jared & Gail for reassurance. I'm fairly sure I do not reference constraints in anything permanent.

Jared - In MySQL, to drop a default constraint, the syntax is thus:

ALTER...

DSquared -

I recently moved to a new server so had a need to move my certificate as well. One issue is that certificate are also encrypted using the service master...