hi,
I am trying to insert the username of a user into my database whe he/she creates a record or modifies one. the inbuilt SQL function either returns “dbo” or “sa”. I need to insert the current username using a variable. it may be easy for you guys but for some reason i am unable to do so. can you please help. the username is not fed through any control but through a simple variable. how do i reference it in my query.
This problem is driving me batty. please help