Trigger worked in 2008, but not in 2008 R2

Question

Trigger worked in 2008, but not in 2008 R2

nulad01

SSC-Addicted

Points: 412
More actions
May 17, 2013 at 11:37 am

#293982

We recently upgraded from 2008 to 2008 R2. The triggers worked in 2008, but after upgrading to 2008 R2, the triggers throw errors in the program. This did not happen in the past. The error that is received:
Error Code: 14607
Error Message: SQLSTATE = 42000
Microsoft SQL Native Client
profile name is not valid

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

And the trigger definition looks like....

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Looks to me like database mail isn't properly configured under 2008 R2. Just a guess based on the error posted, but Gail is right, we need to see the trigger causing the error to know for sure.

Lowell SSC Guru Points: 323518 More actions · Answer 3

Agreed the error about the profile is the giveaway about database mail.

take a look at this thread and solution i posted a while ago to Script Out your database mail settings;

if you know the SMTP password, it makes the migration extremely easy from one server to another:

http://www.sqlservercentral.com/Forums/FindPost982744.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!