January 11, 2011 at 4:27 am
Hi Guys,
Myself and my colleague are accessing a SQL Server 2005 db through a SQL Server 2008 client. We have both had an issue whilst trying to run an update statment. Myself I got it through the Edit Table window and my colleague is getting the error through T-SQL.
The error is relating to dbmail though and neither of us are using dbmail in our updates.
Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 39 profile name is not validThe only information I'm finding in the search engines is about configuring the dbmail. Does anyone have any idea why we would be getting this error?
Thanks in advance.
Iain
January 11, 2011 at 7:15 am
Hard to know, but it sounds like there is probably a trigger on the table, your security setting is working with it, your co-workers is not. But, honestly, that's a guess. I'd want to see the code you're running, the structure you're running against, etc., to be sure.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply