Hi, when i try to update statistics it says me user doesn't have permission.. can u pls rely how to do that? Thanks
You can update statistics by executing the following T-SQL statement: Code: USE [YourDataBaseName] GO EXEC sp_updatestats Replace YourDataBaseName with your actual database name.
Hye dmitri, I am using above your mentioned thing to update statistics.. but below is error that i m facing... "User does not have permission to perform this action" so can u pls tell me how to do that?
Are you logged in with the primary SQL Login? Is this login properly mapped to a database user and is that user a member of db_owner role? You have to be at least db_owner to run this command against your database. If you still have the problem, please open a ticket with our support department so we can take a closer look at the issue you are running into.
