UPDATEUSAGE syntax

what is wrong with this format.. i need to update all statistics on MES database:

DBCC UPDATEUSAGE MES WITH  NO_INFOMSGS
thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
jimyXConnect With a Mentor Commented:
Try this:
DBCC UPDATEUSAGE ('MES') WITH  NO_INFOMSGS
0
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
You need to enclose it within braces like

DBCC UPDATEUSAGE (MES) WITH  NO_INFOMSGS
Or
as mentioned above with single quotes would also work..
0
 
anushahannaAuthor Commented:
Thank you-
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.