Thanks! I adjusted the settings and the server is a physical server with 786 gig of ram and I have the sql max memory set at 778.

Here is another thing I noticed running the query and maxdops is set to 0 and cost threshold for parallelism is set to 5. I would of thought it would...

• This reply was modified 3 years, 7 months ago by  Jasonb-231582.

SQL server 2012 enterprise, and the app won’t running on anything higher. Already tried 2014, 2016 and 2019 with no luck! The never version only runs on Oracle. It is...

I tried to get them to temporary shut all virus scanning off just to see if it made a difference, but they are against it. Should database servers even have virus...

Beginning to think this is a SQL bug with the DDL_TABLE_EVENTS? Hardly anyone uses these DDL triggers, so I can't find much documentation on it.

I tried that...what gets me is the stored procedure trigger works perfectly and the only thing different is DDL_PROCEDURE_EVENTS.

CREATE Trigger [Trg_TrackAuditManagement_PROCEDURE]
on ALL Server
for DDL_PROCEDURE_EVENTS

It comes up blank.

Sorry..I should of put more detail. The table and trigger create fine, but when you try to create a new table the invokes the trigger is where is what brings...