Thanks! Sorry for not providing all the data.

Dale

I work in a very restrictive environment and xp_sendmail is not an option, because the customer won't allow me to install Outlook on the SQL machine.  Other suggestions?

Actually, the HTML does not come up fine, which is why I'm going down this path.  Gotta love Outlook.

Sorry about that.  Didn't mean to post to the wrong forum.

I'm running SQL 2000 and it would require a download and install to run sqlcmd.  I'll post the output tomorrow from osql and maybe you can offer some expertise?

Thanks,

Dale

I looked at sqlcmd as an option, but the customer won't allow me to install the app. Ideally, I'd like to just be able to format using osql and email...

Mike,

Does my connect string indicate I'm connecting anonymously?  I'm a newbie with this ASP stuff.  Note I can connect using Query Analyzer and Enterprise Manager just fine.  I'm confused about...

MikeC wrote:

Are you using ASP or ASP.NET?

ASP

Go into EM and make sure that your Windows ASP(.NET) user account has access to your SQL Server.  When you access an ASP.NET app anonymously...

Hello?

Okay, I'm a little confused guys (I know, not hard to do).  As I stated I above I can log in successfully using Query Analyzer or Enterprise Manager using RUNAS...

Just tried them both; same error.  Other suggestions? 🙂