Hi Phil,

I have installed the DTS SMTP Mail task.exe but getting the error message:

"The procedure entry point GetAddrInfoW could not be located in the dynamic link library WS2_32.dll"

I have admin rights...

Hi Sushila,

suser_sname() prints the same user as user_name().

Here is my trigger:

CREATE TRIGGER [track_time] ON dbo.ATTENDEES

FOR UPDATE

AS

UPDATE ATTENDEES

SET timestamp1=GETDATE(), User_name1 =suser_sname()

FROM ATTENDEES

JOIN deleted ON ATTENDEES.FTKey=deleted.FTkey

AND ATTENDEES.Day1<>deleted.Day1

Hi Sushila,

Thanks for your suggestion. Is there a way to get the system to read user_name() from the USERS table? It is picking the DBO, and not the logged in user.

Thanks...

Hi,

Yes, I can add UserID to the ATTENDANCE table but how will it be populated?

The attendance table key field is FTKEY, other fields are course and delegates information like CourseCode, CourseDescription etc. In...

Thanks, that works fine also.

Thanks, it works fine.

Hi Richard,

Thanks very much I will look at the article more closely. My last question. The Access database with the ODBC links works well on my pc but when I...

Please, where should I look for the MAPI client?

Thanks

Hi Richard,

Works very fine. How can I ask for parameter values set in the sp in a the Access passthrough?

Thanks a lot

Works fine but prompts for Data Source. Any way to avoid the prompt?

Thanks.

Hi Amit,

Given the following details could you please quickly put together a trigger to send the last added name. I plan to use xp_sendmail but still trying to configure the MAPI.

UserID int 4

UserName...

The SQL Query analyzer is able to display my NT login id.

Why isn't it possible to pass this id to a trigger? Wake up guys.

Hi Chris,

I have implemented your suggestion and changed the User to SUSER_SNAME() but it still returns eut2 on any pc. Anything more I can do?

Unfortunately, the two tables have nothing in common except that they are both located on the same server.

Thanks

I am asking if it is possible to update User_name1 with the current user who has logged in the wesite with details in List 1.

Thanks.