How to update statistics after creating index

[wheelsimcom]

Hi,

when i try to update statistics it says me user doesn't have permission..

can u pls rely how to do that?


Thanks

[dmitri]

You can update statistics by executing the following T-SQL statement:

USE [YourDataBaseName]
GO
EXEC sp_updatestats


Replace YourDataBaseName with your actual database name.

[wheelsimcom]

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?

[dmitri]

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.