Viewing 12 posts - 1 through 12 (of 12 total)
Hi Vladan,
thx for the input, I discussed my proposed solution with client and supervisor and the triggers will only be used on 2 tables as these tables carry counters that...
November 8, 2007 at 2:12 am
Lowell, as far as i know the inserted and deleted tables will have the details of your post in it while the trigger is firing. Thus the deleted table will...
November 6, 2007 at 10:34 pm
Thanx for this: select serverproperty('servername')
Took me 20min of searching the forums, but finally found what I was looking for,
this works great
thx again
November 6, 2007 at 5:39 am
That's what I thought. For now the client will have to be satisfied with workstation name as it was them that wanted std sql login instead of (our suggestion) using...
October 10, 2007 at 7:26 am
Thanx Kenneth.
I was wondering if there might be a cmd command that can be run to check the username.
Maybe it could be derived by getting the HOST_NAME() to check...
October 10, 2007 at 7:00 am
Thx, this will only work when using NT Integrated security, if you are using sa blank password it will return sa
October 10, 2007 at 4:34 am
thx for the reply
When running in command prompt i get what I want : username=theoj
When running in SQL2000 Query analyzer i get "Environment variable USERNAME not defined" as you said
This...
October 9, 2007 at 10:29 am
Does anyone know what / how you would get the actual username used to logon to windows for the workstation firing the sql?
HostName and IP not sufficient for my purposes.
Maybe...
October 9, 2007 at 9:51 am
Tank you to all for the help provided. I used a combination of te solutions provided to come up with the solution required + a little customization. In the end...
July 22, 2007 at 2:49 am
Thanx for this. The alter database statements works great. Got it working on the first try.
Thanx again
December 13, 2005 at 2:53 am
Thanx to everyone for the help. Much appreciated.
Thanx especially for the link to the system table map help file. what a wealth of info.
Great programming to all.
Theo
November 17, 2005 at 12:31 am
Viewing 12 posts - 1 through 12 (of 12 total)