Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: creating table when session is invoked

    Hi,

    When I invoke a session in SQL Server I would to create few temp tables. I have got the queries in a file. Is there any way to invoke these queries (Creating Temp tables) whenever I invoke a session.

    Any suggestion/guidence would be greatefully received.

    Regards,
    SAM

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This just smells like a bad idea to me. I don't know of a way to do it with the present generation of SQL Server tools, but I've never really given it any thought.

    Can you give me an example of how this would help?

    -PatP

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Lets make sure we're all on the same page here. SamCute, can you define what you mean by a "session" in SQL Servers.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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