Hello,
when I try to save User-Specific-Settings, I got an error back.
Greetings
Martin
@Martin - Could you please send us your DB schema for analysis. File -> Data Sources -> Upgrade (tab) -> "Email Schema to Support"
Please add: "Attn: Stefane" in the subject.
Best regards,
Stéfane Lavergne
Could it be that this database has been move/restored from a different/same server?
Please run the following:
select name as [DB Name], suser_sname(owner_sid) as [Owner] from sys.databases
where Name = DB_NAME();
GOYou should see something like:DB Name Owner
-------------------- --------------------
RDM null or sa
(1 row(s) affected)
In the case where you see <null> then the issue is due to the database no longer has an "owner" and since we run a few triggers using the "with execute as owner" it is causing the issue.
The solution, run the following:ALTER AUTHORIZATION ON DATABASE::RDM TO sa;
GO(Make sure to replace RDM with your database name and sa with a user you want to own the database. sa is a good option
Let me know if that resolves it for you.
Best regards,
Stéfane Lavergne