Thanks, that is a good suggestion. I checked the job properties, but it does appear that the job is pointing to the correct database on the production server. Also, since...

Great point, thanks.

---

webrunner

I think IT, medicine, and law intersect in interesting ways.

Medicine is the most obvious case where lives can literally be lost if mistakes are made. But so can law and...

Hello Andy,

Yes, the mini-review format is useful. Frankly, I am happy to see any discussion of SQL books.

Something I have noticed is that SQL books are extremely expensive on...

You took the words right out of my mouth. I understand that someone might naively think that password uniqueness is some kind of extra security. But telling someone that they...

Hello,

Sorry to take so long to respond, but I wanted to thank you for this code. It worked exactly as needed! I am still a little amazed at the syntax...

Thanks for all of the in-depth comments!

Due to time, I decided not to work on the query side as suggested above. Instead, I decided to put the values in the...

Sorry, I was unclear in my terms. I meant "temporary" table (not "intermediate" as in linking table for many-to-many relationship).

Thanks to everyone for the suggestions -- I'll test them out.

Another...

Honestly, I never used FoxPro, but I was nevertheless a little sad to see the news that it's being retired. However, if it will live on as a quasi-open-source project,...

Maybe it is this page?

Critical Update for SQL Server 2005 Service Pack 2 (KB:933508)

http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en

-webrunner

Thanks for the additional information. Do you have a page or a link for SP2a (or is it called the SP2 hotfix - or both)?

Thanks again,

webrunner

Hello Paul,

Yes, please post more details on using the Jet 4.0 text driver for this type of query. Others have also mentioned Reporting Services and also trying to determine if...

Thanks to everyone for their replies. I'm responding to Dan in particular since he asked a couple of questions. Regarding those questions, I don't have answers yet because the database...

I'm late to the party, but here is a quick comment.

I don't visit slashdot often, but when I do, there are usually some really interesting user comments posted. But I...

Yes, it may be more fuel indeed. I'm sure there will be XQuery advocates, just as there are of all technologies. But the core SQL paradigm has been so successful...