your problem is that any operation such as dropping a table is causing your trigger to run which is causing your error.

Try dropping the trigger first:

drop

What about using the script database function in sql server management studio? Right click the DB, script database as, create

The only way I can think of doing this is to use triggers.

Could you use a default constraint to generate a new id if one is not supplied?

I thought that even if Pluto was no longer technicaly a planet under their new clasification system it would retain its planet status for historical reasons.

It is only auditing the failed attempts .

Thats what I was looking for, thanks.

Ah, thank you. There I was thinking alter schema would be for changing properties of the schema.

I see the reason for the change, and for me it is helpful. Just...

Could you not use two stored procudures instead of that loop and case statment?

E.g.

CREATE PROCEDURE dbo.usp_InsertAnswer

  @SurveyID int,

  @QuestionNumber int,

  @AnswerText text

AS

  IF @AnswerText = '' OR @AnswerText IS NULL RETURN

  INSERT INTO #Answers_table...