Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Source of update

Author  Topic 

erics44
Starting Member

12 Posts

Posted - 2009-12-01 : 06:52:48
Hi
Is there a way of telling where a sql statement is coming from.

For instance

can i tell if an update is coming from a website or from inside the database like a trigger or something without adding any fields say to record its source?

Thanks in advance

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-12-01 : 07:54:26

Have a column in the table with default value of app_name()

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

erics44
Starting Member

12 Posts

Posted - 2009-12-01 : 08:22:00
thanks
Go to Top of Page
   

- Advertisement -