Share
ReportHi All,
I'm unable to delete a user from SL 2018. Here's the error...
Thanks.
You’re offline. This is a read only version of the page.
100
Hi All,
I'm unable to delete a user from SL 2018. Here's the error...
Thanks.
I would definitely backup the databases first. Depending on the severity of failure, you could restore the backups to a new name, script out the failing object as "alter", then run the script in the production system (either application or system database.) If all else fails, restore the databases under the original name and move forward.
Good morning Stuart,
From what I could tell in our databases, the customized objects have "x_" prefix in the object name (e.g. x_CustomObject). I don't know if any of the stock objects were edited or modified. I guess I could backup the databases before running the "Execute Master Indexes, Views and Stored Procedures" and restore the system and application databases if we experience failure in testing - which must be extremely thorough. Would you agree?
Thank you very much Stuart.
Good morning, Ed. I'm going to reply to both of your most recent questions. First, it will affect both system and application databases.
My experience has been if the views, indexes, procs are COMPLETELY custom (in other words, they were added to existing "stock" objects) the "Execute Master Indexes, Views and Stored Procedures" process will not affect them.
On the othe hand, if by custom you mean that the stock versions were edited, then the process will overwrite and remove any customizations.
Stuart, yes found it there on the app server under the Administrative Tools.
Do you know if "Execute Master Indexes, Views and Stored Procedures" only updates the system database or does it update the application databases as well? I guess it's best to backup all the databases before running the update.
Thanks again Stuart.
Ed, are you sure it's not on the app server? It would be listed under Windows Administrative Tools.
Ed, it looks like you're missing the primary index on the <systemdatabase>.UserRec table. I'd be wondering if there weren't other indexes missing. You could try running the Database Maintenance\Execute Master Indexes, Views and Stored Procedures process.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (