Just to add, you can enable the trace flags with the -1 switch/parameter without needing to restart SQL Server (which is not ideal in production environments), So, you can execute dbcc traceon (1204,1222,-1) which enables the trace flags for all (global) sql server sessions without the need to restart...