Make sure you have the @width parameter set or you'll encounter formatting issues like the one you mentioned.

For example:

 exec master..xp_sendmail @recipients = @v_RecipientList,

     @query = @v_sql,

     @attach_results = 'true',

    ...

Thanks for the reply, Steve.

As a general FYI, we're moving our SQL server inside this week.  The Microsoft Office login was a Server Office Extensions Timer service installed as part...

Thanks for the input, guys, much appreciated.

To Don -- I have heard of that Kimball fellow, I've always heard he's The Man in data warehouseland.  Sounds like our likely option...

We use the diagramming tool in SS2K itself.  Though admittedly not portable, even between identical databases.

Had this happen at a client's site.  Check the available space on your backup drive.  You need enough space to do a current backup AND make a copy of yesterday's backup. ...

WITH SCHEMABINDING attempts to create a view as an indexed view. 

From Books On Line (BOL):

>>>>

Tables and user-defined functions must be referenced by two-part names. One-part, three-part, and four-part names...

You CAN create indexed views on Standard Edition, we have it going at a client site.

Zdenek, you cannot use a four part name in an indexed view, so  "FROM  PRO..SAPR3.BKPF"...

Yep, bad idea.  You just know SOMEONE's going to forget and drop an object.

Might this help?

http://qa.sqlservercentral.com/scripts/contributions/1078.asp

Haven't used it meself, just saw it one day and saved it. 

Accesses a vbscript regexp object, which I have used from VB code with great success.

Good...

Or you could look at something like this:

http://portal2.legato.com/products/costandbyserver/sql/

We just installed it at a client site and are watching it carefully.

Pros:

- No intervention required on failover

- Once it's config'd and...

There is no error returned, nothing in the event log or the SQL logs.  Everything works as it should, just that xp_sendmail doesn't.  Couldn't find anything on msdn, will do...

Actually, it used to be exec (@v_sql).  I changed it as part of my fruitless debugging session.  Sorry, should've mentioned it.

Vik

Wait a sec, Bas is absolutely right: a barcode is just a special font representation, really, of standard alphanumeric data.  Never mind the image-in-DB vs. image-in-file debate for now.  Unless...

Vince,

Don't worry, I shall grant your wish.

I would have gladly avoided this thread had it been in the "Anything But SQL" forum.  Unfortunately, I was confronted with this issue squarely...

Offending people is not the point, Clint.  Nor is American-bashing.  The site's stated purpose is for discussing and assisting others in regards to SQL Server.

I have no issues with folks...