ASE Quiz Question Randomizer
 
Randomly selected quiz question (want a different question? Click here):


May 2003
As we all know, probably through finding out the hard way, you cannot create a table inside a trigger since DDL is not allowed in a transaction by default. To allow this anyway, you need to enable the database option ddl in tran.

The question: how can you create a table from within a trigger without using ddl in tran ?
(hint: this is already possible since at least version 10, so it doesn't involve CIS...)


Click here for the answer.



More ASE quiz questions: 2013 - 2012 - 2011 - 2010 - 2009 - 2008 - 2007 - 2006 - 2005 - 2004 - 2003 - 2002 - 2001
For a randomly selected quiz question, click here.


 
 This document is located at www.sypron.nl/quizrand.html