hi guys,

i have column in my table for username and updtime ,i want to save the login name and date.time of this user if he edit/add a row in my table
how can i do it?
windows2003 ,security integrated with sql2000
m using vb.net

Have a field for all and keep updating on the even.

at the Insert option u keep the field value as "A" and for edit as "E" and for delete "D".

Also filed like userID, updtDate, updtTime as to be updated on event.


Gokulan Ethiraj

This could be a useful tip :
http://p2p.wrox.com/topic.asp?TOPIC_ID=20561

Gokulan Ethiraj

hi Gokulan Ethiraj,

tnx for reply but it doesnt solve my problem, can u pls elaborate more, or do u have any other suggestion,

waiting for ur help:)

How do you pick the login name? Is that the login that is used to connect to sql server or the one used in frontend app to get updated on to that table?

If you are looking to do that from the backend, then...
You may update the columns for username with the login info that comes along when the user tries to update and use getdate() for the other column that denotes update time. I don't see this done easier at the backend as the login information has to come from the frontend.

So I suggest, if you are looking for help related to doing that using VB.net, you may probably post that on a relavant .net forum here. This is SQL server related forum and not .Net.

Cheers!

_________________________
- Vijay G
Strive for Perfection

ok, i see ur point, tnx anyway

additional

SUSER_SNAME(), - get windows login name

adding this to your column 'username' will default to use name who has log in to using windows authentication

Jaime E. Maccou
Applications Analyst

hi jaime,

SUSER_SNAME(), - get windows login name

adding this to your column 'username' will default to use name who has log in to using windows authentication

sorry i really cant understand what u mean,
how do i use SUSER_SNAME(), in select statement? or pls elaborate
tnx for ur help,
waiting for ur respnse

Please noticed change to spelling of user name.

SUSER_SNAME() is built in to SQL Server

1.You can use it by adding SUSER_SNAME() as a default for your table column default value.

2. using a select statement - SELECT SUSER_SNAME()

Example:
say you have columns

orderid
orderdate
Requireddate
username

select orderid,orderdate,requireddate,SUSER_SNAME()as username
from orders




Jaime E. Maccou
Applications Analyst

tnx jaime :)
now i understand it, I'll try this tommorow in my ofc to run ur code,I'll update this to you what happen