mmclaughlin (4/29/2009)

---

Here is what I would like to happen....

I have an SQL database with 12 tables. All tables are linked to one commmon column "cubs_case_id". What I am trying to...

Technet downloads, unless I'm mistaken, are intended solely for evaluation purposes.

Express is free and can be downloaded and used for whatever you like.

Otherwise, you pretty much need to match up...

I would imagine that's possible through CLR programming. Wouldn't even know where to start, but I would imagine it's possible.

You'd have to have a column in the drop-down that has both values in one column. Access forms can't bind a control to two columsn of data.

Are you looking for Express Edition, or something else?

That's why I prefer tokens as a security measure over passwords.

Another weakness of passwords is (to stretch the underwear till it's worn out), your doctor needs to be able to...

mmclaughlin (4/29/2009)

---

Here is what I would like to happen....

I have an SQL database with 12 tables. All tables are linked to one commmon column "cubs_case_id". What I am trying to...

A server trace that dumps to text files is the best option for that kind of thing. The reason not to use Profiler, but to use a server trace...

It has to go through a schema/compilation lock every time it's run in that case, which means it can only be run by one connection at a time.

I doubt you can do exactly that, but you can definitely send XML to one, shred it into a table (dataset), do stuff to it, and return the modified XML....

Keep in mind that there's another school of thought, that passwords are like underwear. You should have them, they shouldn't be visible nor hidden under your keyboard, definitely shouldn't...

Amen...

I read the studies years ago (1995, if I remember correctly), so I don't have immediate access to them. Here's what I can find online at this time:

While not...

Hard for me to judge the thing without the definition of the second table and the view that you're querying.

Personally, I think passwords are junk.

Encryption keys are one thing, but no person should ever need to know one. They should be system-generated and managed, and biometrics of some...