This may be a stupid reply and you have probably already handled this, but VB or VBScript will not recognize the yyyy-mm-dd date format. When importing data from the AS400...

This should do the trick, although the install is silent without any visual interface as to when it is complete...

<From BOL>

sqlredis is a self-extracting executable file that can be executed...

I do not know how your system is configured, but I have seen this same message on NT 4 with a defective CD-ROM. As the previous post suggested, I would...

Thanks for all of your responses. Yes, Frank, I will still be supported by the vendor. Like I mentioned earlier, I have already ported the backend into a matching SQL...

Thanks for responses, but maybe I stated my problem incorrectly. I, unfortunately, cannot changes the source code since this was developed byan outside party. I was simply wanting to change...

I found the problem. The "problem table" contained some null values. Anyone have suggestions on rewriting this query to account for possible null records in the joined tables?

Juanita... I sent the source via the email address in your user profile. If this is OK, you should get it soon, otherwise give me an alternative address.

Not a problem. I will send the source and you can change as you like. This code came from an article by L.J. Johnson in his "Ask the Windows NT...

I agree with Andy but on several recent projects, I have allowed access to the database only via stored procedures and then set access security on these. If you do...

I found the answer. The "most recent used" list of connections for Query Analyzer is found under the reg key: HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\Client\PrefServers. This key contains six keys for Server0...