SQL Server DBA Tutorial 91-How to Create Server Level Trigger in SQL Server

[@sakijilan7908]

only if you could show things in details, such as PermissionAudit Table that how it was created and how many columns it has that would be big help.

[@joshuaprakash4361]

Cannot insert the value NULL into column 'DatabaseUser', table 'master.dbo.PermissionAudit'; column does not allow nulls. INSERT fails. The statement has been terminated. (Microsoft SQL Server, Error: 515)..plz help

[@prakashsingh6447]

Could you please share the LINK from where you get all the sql scripts for Tutorials.

[@antem.7938]

Thank you for your dedication and excellent explanation. However, I am a bit confused creating the “AuditPermission” table. What datatype have you used? Because after executing your scrips successfully a Trigger has been created but the table has not been created yet in master database. I assume, because of that I am getting an error message when I am trying to create a database. Did I miss any video where you showed how you created that table? Below is the error message I am getting. Thank you! “Msg 257, Level 16, State 3, Procedure dbcreate, Line 11 [Batch Start Line 9] Implicit conversion from data type xml to nvarchar(max) is not allowed. Use the CONVERT function to run this query”

[@TechBrothersIT]

Please check in master, audit trigger comes with installation, you need to disable it unless you are part of sysAdmin.

[@antem.7938]

TechBrothersIT Thank you

[@joshuaprakash4361]

where should we create a permission audit table and how?

[@mallipudisairam]

After running your script ,when i tried to create new database it's said invalid object name master.dbo.permisiionaudit error please help me.

[@TechBrothersIT]

Did you create trigger to log who is creating a database? Also in master there is already a trigger, disable that and you should be able to create database, now can you explain what exactly are you trying to do?

[@mallipudisairam]

Thanks for your reply,it's working now,the problem is i forgot creating permission audit table,after creating it it's working fine.