[dba-SQLServer] SQL 2000 question

Arthur Fuller fuller.artful at gmail.com
Sun Apr 22 18:59:18 CDT 2012


It's been several years since I have had SQL 2000 installed locally, but
lately I've had occasion to use it. Fortunately, SQL 2005 is also
installed, so I can use SSMS instead of resorting to the dinosaur
Enterprise Manager.

Currently, there are 5 procs executed in sequence. Each uses one particular
table, scoping it by a date range and another parameter, then joins the
result to a second table to obtain values to update the original table. The
procs are always executed in sequence.

Now, my question. Does SQL 2000 support global temp tables?

If so, then I could create the temp table once, and share it among the 5
sprocs, letting each of them join to its  table of interest to obtain the
values to use in the update.

If not, then I could create a local temp table and fold the 5 sprocs into a
single larger sproc, but I'd rather not do that because I like the
atomicity of the current setup (each sproc doing exactly one thing).

Can someone with either a good memory or a copy of SQL 2000 installed
please check this out for me?

TIA,

-- 
Arthur

The most likely way for the world to be destroyed, most experts agree, is
by accident. That's where we come in; we're computer professionals. We
cause accidents.

-Nathaniel Borenstein<http://www.quoteland.com/author/Nathaniel-Borenstein-Quotes/63/>


More information about the dba-SQLServer mailing list