Shandy's Blog

Where Andrew Sutton, aka Shandy rants and rambles on as the fancy takes him

This blog hosted by:
http://blogs.vbcity.com      
  Home :: Syndication  :: Login

My name is Andrew Sutton, aka Shandy.

I am currently living and working in the UK within the garment industry as an IT specialist. This blog contains mainly IT related issues.

I was a Microsoft VB MVP for a couple of years (Apr 2004-Mar 2006) and was a vbCityLeader between April 2003 and June 2007.

If you are looking for my Sri Lanka or Morocco experiences check out Shandy's Sri Lanka Blog or Shandy's Morocco Blog.

AugSeptember 2008Oct
SMTWTFS
31123456
78910111213
14151617181920
21222324252627
2829301234
567891011

Articles

Archives

Topics

Image Galleries

.NET

Blogs I Read

Others

VB.Classic

In SQL Server 2000 the @Attachments parameter for the xp_SendMail stored procedure allowed you to pass attachments in the format "\\servername\sharename\filename;\\servername\sharename\filename;". However, when using the sp_Send_DBMail stored procedure @file_attachments parameter this format is invalid resulting in the error message:

The format of the parameter @attachments is incorrect. The file names must be separated by a semicolon ";".

Note also the incorrect naming of the parameter @file_attachments as @attachments. Instead you need to use the format "\\servername\sharename\filename;\\servername\sharename\filename".

posted on Thursday, May 24, 2007 4:11 PM

Feedback

No comments posted yet.

Post Feedback

Title:
Name:
Url:
Comments: 
Protected by Clearscreen.SharpHIPEnter the code you see: