As I browse forums, I generally become a taker because my vast ignorance is exposed by the quality of some of the discussions that sparkle over my head. But then,...

All of these options are good.

One useful thing I've been doing a while is using phrase-based passwords rather than some obscure combination of alphanumerics. This isn't suitable for all purposes,...

I have no qualms about falling on the side of the argument that maintenance shouldn't be a fee-based element of the business process, but I do think the idea only...

I will pass the links along to the lads. I probably passed the one before, I think, as it is quite familiar.

Then they willc laim they had no time to...

I spend most of my time as a controller these days, and see problems on both sides of the fence. I still develop just to keep a hand in, and...

So true. I've been lucky the last seven years to have worked on a product/project where I had total control end-to-end, where talking with the developers was possible and a...

For all intents they seem to seldom, if ever, delete anything from any of the interfaces. I will certainly bear that in mind, though.

I suspect my block on this is...

Thanks for the thoughts.

I foolishly forgot to mention that part of the end-result of this upgrade is to move it to SQL Server 2005, and as such the "includes" option...

There is one potential place where a unified form of a lookup table is handy, which is when the table contains a limited amount of static information. In that scenario,...

I can't add much to what was written, except to extend another consideration: those unique and arbitrary integer-based primary key identity columns can be very handy if your front-end can...

Sanjay, the simplest approach without separating tables by type is to isolate your call in a stored procedure and have your top-level interface call it with a parameter for type....

The "can do" attitude is fine (I have it, and always have), but we need to inject an additional dose of user-reality into analysis of from where the problem comes.

Part...

I did run it (though I too have forgotten that step more than once); and I just checked to find on both boxes TCP/IP and named pipes remains activated.

I wonder if it...

I will certainly check named pipes. I thought I had the two identically configured, but certainly I could have missed a click.

What I find odd is that almost all references suggest "."...