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
  Community Forums :: vbCity.com :: DevCity.NET

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. My personal (Non IT) blog is now at Shandy's Place

AprMay 2007Jun
SMTWTFS
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

Articles

Archives

Topics

Image Galleries

.NET

Blogs I Read

Others

VB.Classic

Thursday, May 24, 2007 #

SQL Server 2005 : Using sp_send_dbmail With Attachments With a SQL Server Authenticated Username
In SQL Server 2000 I used a SQL Server authenticated user name to send emails with attachments using the xp_sendmail account. However, in SQL Server 2005 I was unable to get xp_sendmail working and after switching to using sp_send_dbmail I initially still couldn't get my SQL Server authenticated account to send emails with attachments. In the end I had to give the SQL Server authenticated account sysadmin rights. Not a very satisfactory solution but a lot easier than switching to using a windows authenticated account.

I'd be interested to hear if anyone has a more elegent solution

posted @ 4:21 PM | Feedback (1)

SQL Server 2005 sp_Send_DBMail @File_Attachments Parameter Does Not Allow Trailing Semi Colons
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 @ 4:11 PM | Feedback (0)