hmmm...it may just be the inability to scroll to the right...it just so happens to be too wide for my online mail UI.

might not be an issue with your HTML...

Thank YOU!!!! (a thousand times)

By the way...the same symptoms come through on the daily newsletters. Most days, the editorial section is plagued by the same type of "right side"...

...also...shouldn't have to say...but I will add anyway

Be ~PAINFULLY~ carefull when working with any of the system objects !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

The parameters for a stored proc are kept in the sys_columns table of a given database.

The following query can be used to review the basic schema (user created stuff) for...

If you're just trying to compare what native Access will do with SQL data, then you're basically correct.  Native Access with linked SQL tables will suffer greatly at the hands...

As minor as it may seem...that's still a solution.

It's usually the simple things that are overlooked when something is causing a problem.

Many times (myself included) folks take off on the...

Helpful hint:

Please post your solution.

Even though you fixed the problem yourself, your solution may, in fact, help someone else down the road.

Using your regular ASP connection as an example:

Set objConn = Server.CreateObject("ADODB.Connection")

strConnection = "DSN=[data source name];Database=[database name];"

strConnection = strConnection  & "UID=;PWD=[password]"

The "UID" and "PWD" in this connection string need to...

Post a sample of the connection string that is being used in the ASP.NET page/application...

Got it!

My apologies to racosta, I didn't read the xp_sendmail specs in Books Online.

I've already tested and it's exactly what I wanted.  This is for basic alerting and things...

Administration:  I only have one server so that's easy

Reports:  I am not talking about administrator reports...I am talking about end user type stuff...my original email mentioned a Sales report that...

All right:

1.) went through the DCOM settings on the server

2.) made sure DLL's were registered on client

3.) even reinstalled SQL Server client tools...

It still doesn't work. I'm back...

found it...

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B280101

OK, since the service is starting as "Administrator" I went down to the server and tried to debug in query analyzer...it worked!

Since I'm a freshman at SQL Server, I'll need...

NO, it's actually being started under the domain Administrator's login.