So why would I want to use AWE?

>Which OS you are installing it on ?

XP Pro

>did it show any eror message that it is not installing >database server and installing only client .

Nope. I ended up...

Great article - Unfortunately it the fix is for Personal Edition on Windows 98 or ME.

We are running Standard Edition (sp3) on a 2000 server.

It is a maddening error -...

This was what I was doing - only I was trying to do it all in one string rather than using the concatination of the string with the escape characters....

So...

Thanks!

BTW is that one double and one single quote around critical, or is it three singles?

There is one option that may speed up your queries. Write all the sprocs for each possible variable combination (or the most commonly used ones.) These can be...

Sure

SET @MailMsg = '78 load ran correctly'

-- Actually this is built dynamically in a

--case satement, and is only one of the

--possible results for the mail message

EXEC master.dbo.xp_sendmail

@recipients...

Worked like a charm - I only made one change - I added the line

SET @count = @count + 1

Right after the select statement. Here's why: If we are...