Are there any dangers of using Context_Info()

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)

Are there any dangers of using Context_Info()

Author

Topic

steppinthrax
Starting Member

27 Posts

Posted - 2010-02-15 : 20:54:13

I'm using this to pass data to my triggers. Is this a global variable, as such if other users are using context_info at the same time they can modify the intended value?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-16 : 01:05:41

see

http://msdn.microsoft.com/en-us/library/ms180125.aspx

CONTEXT_INFO value wont be affected by other batches that run simultaneously

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources