Thanks for sharing Perry - I am getting an error about incorrect syntax on line 305 of the script:

    DELETE FROM #schperms WHERE GDR=@GDR AND ermission=@Permission">Permission=@Permission AND...

Hi Perry - i've just realised what you are saying - sorry. So you mean use the same name for the listener as the existing alias - but just delete...

Thanks Perry! Unfortunately I can't delete the alias because deleting the alias would bring down the production system! So many things point to the alias. I get what you are...

Beatrix - that sounds like a great plan! I hadn't thought of that. Thanks for the advice 🙂

What about using Contained Databases instead to get around this problem? If you set the database Containment property to 'Partial'  then you can use contained users, which means there is...

Thanks Anthony... i now realise that some of the previous scripts I was using wwere actually working - i was getting no results because they were no explicit permissions, though...

Just carrying on from Perry's advice, if you are a DBA without Domain Admins permissions, but want to control as much of the install as you can, make sure the...

I know last post was 6 years ago 🙂

Just wanted to clarify that if using the ALTER DATABASE MODIFY FILE method, then taking the db offline as some...

Figured it out guys - it was referencing an external assembly! Once the dll was deployed to the SSAS server, it all worked as expected 🙂

Good suggestion - just wondered if there was any other way to do it as there seems to be a number of ways to migrate RDL files around....

So sorry for late reply - I was on holiday and unable to get access to the internet.
I also initially had thought it was a local DNS cache issue....

Hello Chris! Sorry for the late response, I was away for a few weeks without access to e-mail. This script works an absolute treat! Thanks for taking the time to...

Hello Chris! Sorry for the late response, I was away for a few weeks without access to e-mail. This script works an absolute treat! Thanks for taking the time to...

Thanks Chris - I will look through the FOR XML syntax and see if I can figure it out. All new stuff for me but interesting! Thanks for taking an...

Drew - yep, I can confirm AND doesn't work, for exactly the reason you've said...