Did you use a semicolon instead of a colon as this error message would indicate?

I didn't know about it and I am hardcore.:hehe:

Hi Bob,

The read uncommitted thingy might help by reducing the overhead of taking locks on the tables. It won't help the execution plan, but it could cut down on...

Another thing you might try is to use the READ UNCOMMITTED transaction isolation level. That will reduce overhead to some degree.

I feel your pain. Sometimes we just have to do things the wrong way.:hehe:

If you can rewrite the procedure so that it processes in chunks, you can put...

I think you should turn off the /PAE switch and disable AWE since you only have 4GB of RAM.  See http://support.microsoft.com/kb/274750

Looks good to me.  A few quirks, but overall it's very clean and pretty.

And the avatar thingy works now!

In the words of a (slightly) famous forum ex-administrator...

"You'll get over it."

Hi Carlos,

IIRC we talked about this a few years back.  I figured out two ways that you can get what you need.

The first way, as EdVassie suggests, is to control...

Hi Josef,

A windows executable can be downloaded from a link on this page  http://www.cs.bell-labs.com/cm/cs/awkbook/index.html 

There is also a GNU version called GAWK somewhere out there.

AWK is a shell utility that has...

Excellent stuff, guys.

I noticed that my awk program is too long.  It just needs to be "lc++"

The following CMD will create a single file for all of the files in one folder, minus...

To merge the files, I would use a language called AWK to remove the 1st line from a file using a program such as:

{if (lc++){print}}

then create a batch file that would...

I really like merge replication.

You might consider maintaining these tables outside of the transactional publication, handling these few tables by some other mechanism.

"I understand that after AWE is enabled, SQL will reserve as much RAM as possible at boot up"

When the SQL service starts it will reserve the memory, not at boot...

Indeed, but TELNET is a quick and dirty "Is such a port open" test. 

Check the error log on the SQL server.  It will tell you if TCP is enabled. ...