Publish well written standards, Enforce them. Period.

I leave it at FULL because my database backups will try to do log file backups on any database not in the SIMPLE recovery model.  That proc is also setup...

Honestly not fussed on the harshness of response if it contributes to moving the discussion forward - obviously meant in good humour.

It does sound like there are different opinions...

I also put something like that together where it would look like this

where ([definition] like '%INTO [tableName]%' or ([definition] like '%update [tableName]%')

That got me the closest...

Heh......

It also sounds like a possible "connection leak" in the applications that are hitting the database.

Unfortunately, I don't have a say about the structure of the table. It's populated via an ETL process. I just want to create dummy data for testing so want...

You could just search the "definition" column of sys.sql_modules for the table name with the understanding that it won't find ad hoc queries.

The real key here is... are people going to carry you down the hall on their shoulders if you make any changes here?  If not, I'd leave it all be. ...

My point is... the OP hasn't identified the scenario accurately enough to even try to determine which kind of...

You missed my point... and that's actually OK.  I wasn't suggesting one of the other... I was pointing out that a whole lot of other people do and it's usually...

My point is... the OP hasn't identified the scenario accurately enough to even try to determine which kind of testing needs to be done.

Interesting... thanks, Glenn.

Be careful when testing.  In this case, the OP hasn't defined what he means by "Assume I'm going to insert lots of data".  Does that mean for just one, multi-row...

Assume I have a table with a clustered datetime-index. Assume I'm going to insert lots of data. The data to be inserted is not in any specific order. Would...