SSMSBoost has a version that's compatible with SSMS 2016 with a formatter that can handle RESTORE statements.

http://www.ssmsboost.com/social/posts/m12238-SSMSBoost-v3-0-Beta--2008-2012-2014

It works so much better than any of the paid options that...

Hi Jacob,

Yep, I think you're right. The table's a heap and has a unique nonclustered PK which is being referenced in the WHERE clause of the UPDATE statement.

I disabled the...

Actual plan attached.

Looking at the details for the TOP and SEEK operators, only one row is found so you're right that the TOP isn't removing any rows but I can't...

I've only got an estimate plan at the moment as I'm pulling the statements out of the deadlock xml.

I'll see if I can grab an actual now.

Yes, no problem. sqlplan file attached.

Thank you.

Nice thanks for that. Will be checking that out!

Thanks, it's not the end of the world. It was just a really handy feature that I'd gotten used to and was hoping that there was another product out that...

They're just standard backup/restore statements. I like to generate the statements by using the gui and then give them a once over before running.

So from:-

RESTORE DATABASE [TESTDB] FROM DISK...

Downloaded and installed first the express dbforge version and then the full trial but unfortunately it doesn't work for backup/restore statements either.

Ah well...

Thanks, will give the dbForge trial a whirl

I'm not gonna go for the Red Gate product as even though it does have more features I really just want a code...

Cool! Will wait and check that out when it becomes available.

It's good but I can't see how to get it to format BACKUP/RESTORE statements.

I like to generate the script with the SSMS GUI, script it out and then format it...

Had a look at SQL prompt, bit pricey for a formatter isn't it?

I don't really want to use an online tool, not really that convenient.

It's a shame as the...

Thanks Gail. Yep was thinking that but got asked about it and I couldn't find anything on the web about it

Ha ha, I'm guessing that's a no then? 🙂

If I get to the bottom of this I'll post what I find.