[dba-SQLServer] Altering temporary Tables

David Emerson newsgrps at dalyn.co.nz
Wed Sep 12 21:42:57 CDT 2007


Doing some more research it may be that temporary tables cannot be 
altered.  I cannot create and alter a physical table because the 
application running the procedure is web based and could be run 
simultaneously by several users.

Perhaps there is a way to build a string to run when the table is 
initially declared?  I am not sure that this is possible either.

Anyone any suggestions as to how I can get around this one?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand  


More information about the dba-SQLServer mailing list