Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: global temp table vs. permanent table use

    I need to decide what is better to use: global temp table ( I can't use local one) or permanent table in SQL 2000 stored procedures. I extract data from linked server table and update several tables on our server.
    Those procedures scheduled to run every 3 hours.

    Another question: for some reasons when I used global temp table, I wasn't able to schedule multi steps with every step executing one of the stored procedures.I think global temp tables should be visible to other stored procedures, right?

    Your suggestions?

  2. #2
    Join Date
    Nov 2002
    Only if it's created in a driver sproc, then it calls nested sprocs.

    Otherwise it's gone at the end of the process....

    I'd say create a permanent won't incurr the overhead of using tempdb...

    Sounds like a staging table to me anyway....

    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