nslookup run from a command prompt will allow you to do the reverse lookup.

Helen's suggestion sounds like what might be happening.

One other thing. It seems you are setting values in a table to "N", then the remaining values to "Y". You could do this in one statement with a CASE...

From my understanding, which may or may not be correct, SQL Server Std can only use 2GB from memory from the OS. That should be physical, but potentially if the...

Not a great full text expoert and we had some issues with it as well. We went with SQL Turbo on the site here from Surfinity. Working great and indexing...

Is it added as a resource somewhere or is it the quorum?

I agree with Clice. He's got the two best ways to accomplish this. Profiler is less invasive (monitoring only), though you could build a trigger to just insert logging informaiton...

In general in the computers I've worked at the DBA has a higher status. Not usually because of the position, but more because they tend to be more experienced and...

Ask and you shall receive.

Scripts are sortable. Give me another day or so and articles will be as well.

Apologies, you are correct in your grammar analysis, Henry. It should be "Andy and me" when it's an object in the sentence.

My mistake. I must have put it in their twice. Sometimes when you're doing this in advance, it gets confusing.

You can start a transaciton that locks the record, but that is not the proper way to deal with rows in SQL Server. In general, if you want to prevent...

Ah, but Frank, it also proves you care something about your career to invest time in it. That may be the most important thing.

Andy Leonard put it well on...

That reminds me of the old Westinghouse computer in the nuclear reactor. The one that actually drove the very basic functions of the original control room. It was a 1MB...

Sorry, it's probably misworded slightly, but basically 2NF from my understanding, involves moving things to lookup tables. So if you have a City repeated multiple times in a table (multiple...