two simple questions

• ahughesdba

  Grasshopper

  Points: 24

  More actions

  May 8, 2003 at 8:41 am

  #80024

  i'm new the world of sql server...

  1. Can Sql Server do logon triggers?

  2. Can I store session variables e.g. when a user logs on, select a value from a table

  and store that somewhere in memory so i can use it in other select statements...

  thanks for any help.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  May 8, 2003 at 3:17 pm

  #456598

  1. no

  2. you can "fake" this by storing them in a table and using @@spid to track them to a user.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net