How Do I Create And Execute A Temp Table Inside A Trigger In Sql Server 2012

See more:

SQL-Server-2012

I need to create and execute a temp table inside trigger with a specific table name in sql server. when I write the sql script to crate the temp table it's created but something different table name used hex code. please give the solution at your earliest. I am providing you a test trigger for delete sql script below:

ALTER TRIGGER [dbo].[trdeleteOperation]
on [dbo].[Person]
after delete AS
begin
--********************** #temp table ************
IF OBJECT_ID (N'#tmp') IS NULL
BEGIN
BEGIN TRY

CREATE TABLE #cmmsGlobal
(
AuditUser varchar(36) not null default '',
AuditIP varchar(39) not null default '',
AuditNotes varchar(4000) not null default '',
AuditClientUTC datetime not null default getutcdate()
)
INSERT INTO #tmp(AuditUser,AuditIP,AuditNotes,AuditClientUTC)
values('','','',getutcdate())
END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() AS ErrorNumber;
END CATCH
END

--******************************************

END

After trigger fire the temp table name will some hex code (like #B021...) not #tmp. Please suggest and give me an example for this solution or correction the above.