No restart is required. Nor do you need to use WITH OVERRIDE on the reconfigure statement. WITH OVERRIDE is for when you want to force invalid values for config settings,...

Tables don't have a collation. Columns have a collation, so to change the collation on one or more columns in a table, you need to run ALTER TABLE.. ALTER COLUMN...

You can't execute a procedure as part of a select.

You're getting the GRANT commands listed out, why do you want one set of commands printed (I assume for later execution)...

If you change that to either get the GRANT or get the EXEC, then it's easy. Something like this (didn't test, so quotes may be off)

select case

when class_desc='OBJECT_OR_COLUMN' then 'GRANT...

Because the index is 4 levels deep.

Can you post the complete code please?

A proc can't be called as part of a select. What are you trying to do here?

Um, I've told you twice it will have an impact. Is this just a case...

Confirmed then, the problem is the row goal (of 1) which the EXISTS is forcing into the plan. Bloody hard to work around to be honest.

It's usually not the efficient...

Please note: 8 year old thread.

Good, so you know the cause of the problem then. Fixing the corrupt DB will stop the stack dumps. Good luck.

A varchar(max) can store up to 2 billion characters.

Can you post your complete code? I suspect the part you've obfuscated contains the problem

Something's throwing high severity errors and SQL is writing out stack dumps to log information which may help identify and fix the problem (severity 22 are severe errors which need...

You appear to have a corrupt database. Got any clean backups?

When did you last successfully run DBCC CheckDB?