Hi,
I have trigger code as below. SQL Server complaint "There is already an object named "#mytable" in the database. But I already restart the server.

CREATE PROCE myTrigger ON mytable FOR INSERT
AS
BEGIN
  IF condition = 'A'
    SELECT * INTO #mytable FROM inserted
  ELSE
    SELECT * INTO #mytable FROM inserted WHERE abc = 'A'
END

If I renamed one of them, the error will be gone.

Please advice.

Thank you