Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    76

    Unanswered: creating temp tables during login

    Frenz,

    I need to create tables that are session specific. i.e When I login to a database i have to create a Table that can be accessed across all the procedures and triggers. When I log out the Tables should be droped. I understand that Local Temporary (#) tables can be created in annonymus block, but I need the tables to be created during login.

    Your response is highly appreciated.

    -Cheeku

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Ensure the TEMPDB has not restricted to a max. size, if so it may fail.
    And ensure the server is not stressed with this approach. In general the temp tables will be dropped once the session is closed at the SQL server.
    Check books online for more information on temp. tables topic.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by cheeku
    annonymus block
    Holy Oracle Batman

    And Why do you need to do this?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •