If you meet the criteria for minimal logging (https://msdn.microsoft.com/en-us/ms190422.aspx) you can use INSERT without the same amount of log file usage

I've had the same symptom occur on a SQL 2012 machine. SSMS Tools was installed which has an option to block TRUNCATE statements, so that might be worth checking if...

It would have helped greatly if the error message had referred to the trigger which failed rather than a different stored procedure.

Ah. Stand down. Just found out one of our DBAs had put a trigger on msdb.dbo.sysjobsteps for auditing purposes, and was storing the updated step code in a varchar(4000). All...

That's obviously an option but I would like to understand the underlying issue.

The reference was in

<DTS:Executable DTS:ExecutableType="Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91">

...

<DTS:LoggingOptions>

<DTS:Property DTS:Name="LoggingMode">0</DTS:Property>

<DTS:Property DTS:Name="FilterKind">1</DTS:Property>

<DTS:Property DTS:Name="EventFilter" DTS:DataType="8"></DTS:Property></DTS:LoggingOptions>

<DTS:Property DTS:Name="ObjectName">SQL_PrepTables</DTS:Property>

...

but there is no task called SQL_PrepTables visible when you open the package in BIDS.

Thanks to both of you. Despite me being adamant there were no spaces in my select statement or table names there is actually an invisible character after the _ in...

Thanks for the reply. I can confirm there are no spaces in the object name or in the SQL code I posted.

I hadn't known about expressions in constraints until now. It is straightforward, isn't it?

Thanks

And when you combine TB with...

Sadly, tuberculosis isn't a thing of the past like smallpox. It infects a third of the world's population and kills over a million people a year.

To be honest, if you added lots more features to the site I probably wouldn't use them. I'm on here most days as it is.

Aha! I've added the SQL Server Agent to the Administrators group on the server, which should do the trick. I believe I'll probably never know what caused the service to...

Most of my colourful descriptions of software are various shades of brown.

I should point out that although the SQL Server service kept running, a user who was online at 20:45 has since reported to me that his database access appeared to...