Error Using sp_send_dbmail

[JohnBates]

hi everyone,

This is 2005 SP2.

I have an unusual problem with using sp_send_dbmail on 1 of our servers.

When I run this it gives the following error:

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'PNCLLWDB',
@Recipients = 'myName@pncl.com',
@body = 'Sent by sp_send_dbmail',
@Subject = 'SQL Server Email is Working on PNCLLWDB';


Msg 8145, Level 16, State 1, Procedure sp_send_dbmail, Line 0
@Recipients is not a parameter for procedure sp_send_dbmail.

But @Recipients IS a valid parameter and I'm using it this way on other servers.

The profile exists and when I right-click Database Mail and send a test email, that works.

This server has 9.0.3054

Any ideas?
Thanks, John

 

[mrdenny]

I'd make sure that no one broke the procedure by accident. Do a sp_helptext on the procedure and make sure that it matches the procedure on your other servers.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[JohnBates]

**SOLVED**

Has anyone guessed what it could be?

This database is for the Lawson application.

Lawson requires that the database be case-sensitive. All commands, etc must be specified with the exact upper/lower case characters.

so @recipients = 'myName@pncl.com' works
but @Recipients = 'myName@pncl.com' fails

I knew this db was case-sensitive. But had momentarily forgotten that this installation is "special".

It really makes for some "challenging" queries especially if they have WHERE clauses.

I think I hate Lawson!

John