Can you provide the DDL and some sample data for the narrativeTest table that you are updating in the trigger?

What do you want to do if the row does not...

My take is that SSC is just not a popular place to post jobs or to look for jobs. This forum is used more for getting help on putting...

Once I learned about Case Sensitivity in the Lookup Transformation I did not use the Fuzzy Lookup anymore. I don't know if there is caching in the Fuzzy Lookup...

Jeff Moden (10/5/2009)

---

Proper calculation of age should never include /365.35. It also doesn't need to be complex...

DECLARE @DOB DATETIME

SET @DOB = '2008-03-01'

DECLARE @Now DATETIME

SET @Now = '2009-03-01'

--===== This is...

Lynn Pettis (10/6/2009)

---

RBarryYoung (10/6/2009)

---

Lynn Pettis (10/5/2009)

---

Sorry, but I'd rather be here in person for those events.

I'm taking a 2 week vacation starting next week, and I may or may not...

Cool, I haven't had time to try it so I didn't know and it didn't sound like you had tried it in a Logon Trigger either. It is interesting...

You should check your Windows Event Log and SQL Server Error Log because it sounds like it was having some issues communicating with AD.

Sorry about that last post. Believe it or not it looks like the LOGON event does not contain ApplicationName. Here is the list of elements for the LOGON...

You can also look into the STUFF function.

Please, please listen to Michael Earl. Look into Service Broker or just roll your own asynchronous solution. Also you could do SQL Server replication.

Looks like, based on the EventData schema, you only need:

@data.value('(/EVENT_INSTANCE/ApplicationName)[1]', 'nvarchar(512)')

Interesting. The user should be able to connect via the group. I am using that on my SQL Server without issue. Do you have multiple domain controllers?...

You might want to check out this site[/url]. It has some examples.

You may also want to check out this blog.

I don't know of a way to find what is only SQL Server 2008 compatible, but you can download and run the SQL Server Upgrade Advisor to make sure you...

I haven't used ntext but the ASCII code for the NULL character is 0 so you could use CHAR(0) or probably better in your situation NCHAR(0).