Thanks for the added comments Luux!
- I use the community version but good to know AD is supported in Enterprise. I would definitely prefer this but more $$.
- I only need to rename databases on the back end when set up new instances of the database for a new client. No more RENAME DATABASE!
- Thanks for the CROSS APPLY link. This will make my life easier.
- Sharing is caring!