Jonathan AC Roberts wrote:I would use an SSMS add-in like ApexSQL Refactor.
There is a free version of it here https://en.freedownloadmanager.org/Windows-PC/ApexSQL-Refactor-FREE.html
I think you only get a trial period with the current version from the Apex site so better to use the download above.
Or if you have a budget and don't mind paying for something I would get Redgate SQL Prompt.
Thanks Man.
Considering what even some "paid for" software does (like hiding malware they didn't know about), I'm mighty leery about downloading and installing just about anything anymore. It's like playing volleyball in a mine field.
--Jeff Moden
Change is inevitable... Change for the better is not.