Drop a Global Temporary Table using Classic ASP -- sql server mseq

juan.oceguera NO[at]SPAM nav-international.com
6/11/2007 1:44:37 PM

Good Afternoon,

I am hoping someone can help me out. I want to drop a global temporary
table in classic asp after my recordset has completed printing out
it's rows.

I tried executing the following statement and I get the following
error:

Drop Table tmm_a03_gtt_YYYJCO3_0611154125

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC driver for Oracle][Oracle]ORA-14452: attempt to
create, alter or drop an index on temporary table already in use

FYI; We are using Oracle 10 g.

Thanks,

Juan

Mohit K. Gupta
6/20/2007 7:57:00 PM

Not sure about Oracle. But in SQL Server you cannot delete a global
temporary table even if one connection references it. So I would check if
there are connections that access it, and kill those. Or wait until those
connections are completed then delete it.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server mseq

sql server mseq : Drop a Global Temporary Table using Classic ASP