select system_user

12/06/2008, 22h49

Hi,

I need to keep track of user/program update sql table.
I created a trigger for the update user filed by
update instacontrol set username = system_user where intmid = (select
intmid from inserted)

Now I need to remote host name which does the insert.
How do I do it?

Thanks,

12/06/2008, 23h05

Mecn,

For SQL Server 2000
SELECT hostname FROM master.dbo.sysprocesses WHERE spid = @@SPID

For SQL Server 2005
SELECT host_name FROM sys.dm_exec_sessions WHERE session_id = @@SPID

RLF

"Mecn" <mecn@yahoo.com> wrote in message
news:OZRAL3MzIHA.4492@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> I need to keep track of user/program update sql table.
> I created a trigger for the update user filed by
> update instacontrol set username = system_user where intmid = (select
> intmid from inserted)
>
> Now I need to remote host name which does the insert.
> How do I do it?
>
> Thanks,
>
>

12/06/2008, 23h30

Can I have the process name?

Thanks a lot.

"Russell Fields" <russellfields@nomail.com> wrote in message
news:%2358sZANzIHA.2188@TK2MSFTNGP04.phx.gbl...
> Mecn,
>
> For SQL Server 2000
> SELECT hostname FROM master.dbo.sysprocesses WHERE spid = @@SPID
>
> For SQL Server 2005
> SELECT host_name FROM sys.dm_exec_sessions WHERE session_id = @@SPID
>
> RLF
>
> "Mecn" <mecn@yahoo.com> wrote in message
> news:OZRAL3MzIHA.4492@TK2MSFTNGP02.phx.gbl...
>> Hi,
>>
>> I need to keep track of user/program update sql table.
>> I created a trigger for the update user filed by
>> update instacontrol set username = system_user where intmid = (select
>> intmid from inserted)
>>
>> Now I need to remote host name which does the insert.
>> How do I do it?
>>
>> Thanks,
>>
>>
>
>

13/06/2008, 07h32

Can you define "process name"?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"Mecn" <mecn@yahoo.com> wrote in message news:umGVMONzIHA.5820@TK2MSFTNGP04.phx.gbl...
> Can I have the process name?
>
> Thanks a lot.
>
> "Russell Fields" <russellfields@nomail.com> wrote in message
> news:%2358sZANzIHA.2188@TK2MSFTNGP04.phx.gbl...
>> Mecn,
>>
>> For SQL Server 2000
>> SELECT hostname FROM master.dbo.sysprocesses WHERE spid = @@SPID
>>
>> For SQL Server 2005
>> SELECT host_name FROM sys.dm_exec_sessions WHERE session_id = @@SPID
>>
>> RLF
>>
>> "Mecn" <mecn@yahoo.com> wrote in message
>> news:OZRAL3MzIHA.4492@TK2MSFTNGP02.phx.gbl...
>>> Hi,
>>>
>>> I need to keep track of user/program update sql table.
>>> I created a trigger for the update user filed by
>>> update instacontrol set username = system_user where intmid = (select
>>> intmid from inserted)
>>>
>>> Now I need to remote host name which does the insert.
>>> How do I do it?
>>>
>>> Thanks,
>>>
>>>
>>
>>
>
>

12/06/2008, 22h49	#1
Mecn Messages: n/a Hébergeur:	select system_user Hi, I need to keep track of user/program update sql table. I created a trigger for the update user filed by update instacontrol set username = system_user where intmid = (select intmid from inserted) Now I need to remote host name which does the insert. How do I do it? Thanks,

12/06/2008, 23h05	#2
Russell Fields Messages: n/a Hébergeur:	Re: select system_user Mecn, For SQL Server 2000 SELECT hostname FROM master.dbo.sysprocesses WHERE spid = @@SPID For SQL Server 2005 SELECT host_name FROM sys.dm_exec_sessions WHERE session_id = @@SPID RLF "Mecn" <mecn@yahoo.com> wrote in message news:OZRAL3MzIHA.4492@TK2MSFTNGP02.phx.gbl... > Hi, > > I need to keep track of user/program update sql table. > I created a trigger for the update user filed by > update instacontrol set username = system_user where intmid = (select > intmid from inserted) > > Now I need to remote host name which does the insert. > How do I do it? > > Thanks, > >

12/06/2008, 23h30	#3
Mecn Messages: n/a Hébergeur:	Re: select system_user Can I have the process name? Thanks a lot. "Russell Fields" <russellfields@nomail.com> wrote in message news:%2358sZANzIHA.2188@TK2MSFTNGP04.phx.gbl... > Mecn, > > For SQL Server 2000 > SELECT hostname FROM master.dbo.sysprocesses WHERE spid = @@SPID > > For SQL Server 2005 > SELECT host_name FROM sys.dm_exec_sessions WHERE session_id = @@SPID > > RLF > > "Mecn" <mecn@yahoo.com> wrote in message > news:OZRAL3MzIHA.4492@TK2MSFTNGP02.phx.gbl... >> Hi, >> >> I need to keep track of user/program update sql table. >> I created a trigger for the update user filed by >> update instacontrol set username = system_user where intmid = (select >> intmid from inserted) >> >> Now I need to remote host name which does the insert. >> How do I do it? >> >> Thanks, >> >> > >

13/06/2008, 07h32	#4
Tibor Karaszi Messages: n/a Hébergeur:	Re: select system_user Can you define "process name"? -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Mecn" <mecn@yahoo.com> wrote in message news:umGVMONzIHA.5820@TK2MSFTNGP04.phx.gbl... > Can I have the process name? > > Thanks a lot. > > "Russell Fields" <russellfields@nomail.com> wrote in message > news:%2358sZANzIHA.2188@TK2MSFTNGP04.phx.gbl... >> Mecn, >> >> For SQL Server 2000 >> SELECT hostname FROM master.dbo.sysprocesses WHERE spid = @@SPID >> >> For SQL Server 2005 >> SELECT host_name FROM sys.dm_exec_sessions WHERE session_id = @@SPID >> >> RLF >> >> "Mecn" <mecn@yahoo.com> wrote in message >> news:OZRAL3MzIHA.4492@TK2MSFTNGP02.phx.gbl... >>> Hi, >>> >>> I need to keep track of user/program update sql table. >>> I created a trigger for the update user filed by >>> update instacontrol set username = system_user where intmid = (select >>> intmid from inserted) >>> >>> Now I need to remote host name which does the insert. >>> How do I do it? >>> >>> Thanks, >>> >>> >> >> > >

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email